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.
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
Posts
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.
ReplyDeleteBut what if you are receiving this error and the database are already set to false
ReplyDeleteThe 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.
ReplyDeleteCraps 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