Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aoriju
Posting Yak Master
156 Posts |
 Posted - 2010-10-14 : 05:35:28
|
| DECLARE @DBName AS VARCHAR(50) , @DataFile AS VARCHAR(50) , @LogFile AS VARCHAR(50)SELECT @DBName = DB_NAME() , @DataFile = FILE_NAME(1) , @LogFile = FILE_NAME(2)DBCC SHRINKFILE(@DataFile, 1)BACKUP LOG @DBName WITH TRUNCATE_ONLYDBCC SHRINKFILE(@LogFile, 1)Please reply asap |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-10-14 : 05:40:28
|
| That's just about the worst mismanagement of a log file possible.Please read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url] If you have any questions after, please ask.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Truncate Log Files 2008(Truncate only not working