April 3, 2008 at 8:57 am
Is it possible to do this? How can I shrink a ridiculously sized log file smaller than its original size?
¤ §unshine ¤
April 3, 2008 at 9:02 am
Use the DBCC SHRINKFILE command.
You can look it up in SQL Server Books Online.
April 3, 2008 at 9:06 am
It only shrinks it to its original file size. I need it way smaller than that.
¤ §unshine ¤
April 3, 2008 at 9:25 am
sunshine (4/3/2008)
It only shrinks it to its original file size. I need it way smaller than that.
That is not true.
You need to read the "Shrinking the Transaction Log" topic in SQL Server 2000 Books Online to get an understanding of how this works.
April 3, 2008 at 9:29 am
ok. Let me take a look.
¤ §unshine ¤
April 3, 2008 at 9:47 am
Hey thanks! My problem was that I was not truncating the log before shrinking. I did a dump tran and it worked! thanks again.
¤ §unshine ¤
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply