Truncate SQL Server Error Log

Truncate SQL Server Error Log

Post by Dan » Thu, 08 Jan 2004 03:43:29



I have a SQL Server 2000 Clustered server that has not
been rebooted in several months and the error log is
approximately 1.5 MB in size. It takes several minutes to
refresh the error log. What is the best practice to
eliminate last month's data from the error log?

Thank You,

Dan
 
 
 

Truncate SQL Server Error Log

Post by Geoff N. H » Thu, 08 Jan 2004 03:56:18

Look up sp_cycle_errorlog in BOL. Run this on a regular schedule and your
problem is solved.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com