Showing posts with label ErrorLOG FULL Sql 2005. Show all posts
Showing posts with label ErrorLOG FULL Sql 2005. Show all posts

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).