August 25, 2010 at 2:54 am
Hi
After a restart of the server my SQL 2005 database will always go into recovery mode. This also happens when I do a restore of the database from the *.bak file. This only occurs with this database. Is the database corrupt?
Thanks in advance
Robert Glover
August 25, 2010 at 3:23 am
Does it Recover anytime after restart? When it is in Recovering state, the entries in the SQL Server Error Log will give more information on the issue
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 25, 2010 at 3:29 am
No, it's not corrupt.
Quite likely you have a very large number of VLFs, which results in slow restart-recovery of the database.
http://sqlskills.com/blogs/kimberly/post/8-Steps-to-better-Transaction-Log-throughput.aspx
http://sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx
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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply