Wednesday, May 1, 2013

Starting up database message in ERROR.log file


We have noticed that one SQLServer Database is starting very frequently and also it is in "Recovery Pending" mode.

Below error messages from SCOM
Database WEBAPP in SQL Server instance INST1 on computer CLUST.sqlserver-expert.com is offline/recovery pending/suspect/emergency

Below messages from  ERROR.LOG
2013-05-01 12:06:53.29 spid122     Starting up database ‘WEBAPP’.
2013-05-01 12:08:04.20 spid123     Starting up database ‘WEBAPP’.
2013-05-01 12:09:14.25 spid184     Starting up database ‘WEBAPP’.

Solution:- You will see this issue then AUTO CLOSE option is set to TRUE in Database properties.

If you set AUTO_CLOSE to TRUE then the database will be closed as soon as there are no connections to it and database will re-open every time a connection is established to it. 

There is no much information from log. But you will see this error when backup is running, because backup job trying to create a  new connection to the database.

Set AUTO CLOSE option to FALSE to resolve this issue.

Management Studio --> Select the Database "WEBAPP" -->  Right Click  Properties--> Options --> "Auto Close" value to "False"

Regards
Satishbabu Gunukula

4 comments:

  1. I see that these facts are something to consider. Database is the foundation of a system and for some errors as such, it could cause a great trouble.

    ReplyDelete
  2. But what if you are receiving this error and the database are already set to false

    ReplyDelete
  3. The 12022 A-2T series is an improvised version manufactured by Bertucci and can be definitely known as the Best Field Watch Under 200 that is a must-buy for you! Unlike ordinary watches, this ideal model will offer you the best features beyond what you can hope for.

    ReplyDelete
  4. Craps is not as difficult as you might assume and you can be taught and begin taking 로스트아크 part in} in just minutes. Craps could also be} the most popular on line casino cube game on the planet. At Turning Stone Resort Casino we offer fast-action craps on a large desk with a variety of|quite a lot of|a big selection of} bet choices and fun props. The House will handle all bets and can charge a 5% commission on all successful wagers.

    ReplyDelete