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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How to truncate a log file

Author  Topic 

entec_van
Starting Member

5 Posts

Posted - 2006-10-24 : 05:52:59
hi,I'm using SQL Server 2000, I have a log file with 50G and I need to return the spaces for disk, so how can I truncate the log file, it's really a big file.
I used Shrink method but it's not ok.
Please help me!

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-10-24 : 05:59:18
see here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210


KH

Go to Top of Page

entec_van
Starting Member

5 Posts

Posted - 2006-10-24 : 06:32:30
thanks
Go to Top of Page
   

- Advertisement -