Tuesday, September 7, 2010

Can not start MS SQL Server 2005 because ERRORLOG full?

Things to do:

  1. Check the MS Sql server 2005 configuration tool and make sure MS SQL server is started
  2. restart the MS Sql Server service ( this will cycle ERRORLOG to errorlog.1)
  3. launch SSMS and exec sp_cycle_ERRORLOG (use master)

P.S check the ERRORLOG it may be a GIG is size (Sql won't start).

No comments:

Post a Comment