October 9, 2009 at 4:59 am
I could see in the logs follwing entries continously for nearly all databases:
CHECKDB for database <database_name> finished without errors on <date time>. This is an informational message only; no use action is required.
<date time> here shown is much older (nearly 1 month old) compared to when we are getting the log entries.
How can any database get into recovering mode automatically?
October 9, 2009 at 8:07 am
Generally when you reboot the sql server service or if system is rebooted, you will see recovering databases logs in sql logs.
Swarndeep
http://talksql.blogspot.com
October 9, 2009 at 8:30 am
This is just an informational message that is telling you that DBCC CHECKDB was run since the last SQL Server restart.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 9, 2009 at 8:54 am
That's saying when CheckDB last ran successfully. It's not saying that checkDB has just run, it's not saying that checkDB ran since the last time SQL was started. The date it gives there is the last time that CheckDB ran without error.
If that date is a month ago it either means that CheckDB has not run since that date or that every time CheckDB ran since that date it found some problems.
It's essentially the last known good date of the database.
This message is printed in the error log whenever a database is started. My guess, you've got your databases set to autoclose. That means that SQL will cleanly shut the DB down when no one's using it and will start it up again when someone accesses it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2009 at 1:19 am
Yes all the databases 'set auto-close' option is on. This is the requirement of application hence set to on. We have almost 2000 databases.
We could see some set of databases in 'recovering' mode for 1-2 seconds and these databases then come out of recovering mode. Another set of databases then go into this 'recovering' mode.
We can continously see such fluctuation for different set of databases.
I exeucted the following query to check each time which databases are in 'recovering' mode:
Select * from sys.databases where state_desc = 'RECOVERING'.
Is it normal to see such state?
October 15, 2009 at 4:07 am
viduvs (10/15/2009)
Is it normal to see such state?
If you have autoclose on, yes. When SQL brings a DB online, it does restart-recovery. It has to.
That you're seeing if for couple sec may indicate that the drive the logs are on is overloaded and taking strain. Check the performance stats for the drive.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply