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 Administration (2000)
 Log file (not transaction) getting large

Author  Topic 

bogey
Posting Yak Master

166 Posts

Posted - 2006-04-12 : 13:35:36
Looking at my sql server logs, I've notice that my current file has grown to 15GB. Is there any way to switch to a new log file? (I have 6 archives and 1 Current)

thanks.

TimS
Posting Yak Master

198 Posts

Posted - 2006-04-12 : 16:23:51
If you mean error logs you can use sp_cycle_errorlog

Tim S
Go to Top of Page

bogey
Posting Yak Master

166 Posts

Posted - 2006-04-12 : 16:29:35
quote:
Originally posted by TimS

If you mean error logs you can use sp_cycle_errorlog

Tim S



Worked like a charm.

Thanks
Go to Top of Page
   

- Advertisement -