Home Forums SQL Server 2005 Administering How to best delete SQL Server 2005 errorlog RE: How to best delete SQL Server 2005 errorlog
Greg Charles
SSC-Forever
Points: 45403
More actions
August 12, 2008 at 3:34 pm
#857072
Actually, if you repeatedly execute sp_cycle_errorlog as Andrew suggests, you wouldn't have to delete the file at all. It would automatically drop off when you went past the configured max number of error logs.
Greg