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 2005 Forums
 SQL Server Administration (2005)
 clear log file

Author  Topic 

sinu009
Starting Member

5 Posts

Posted - 2008-03-03 : 05:10:53
what is the command using to clear the content of log file

CShaw
Yak Posting Veteran

65 Posts

Posted - 2008-03-03 : 17:00:46
I am assuming that you are on full recovery mode and that your t-log is filling up is the reason for your post. Take a look at Backup in Books on line. That should answer your question.

Chris Shaw
www.SQLonCall.com
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-03 : 22:20:35
Use 'backup log' specifically.
Go to Top of Page
   

- Advertisement -