• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 605
  • Last Modified:

SQL 2008 R2 Database going to recovery mode

Dear All,

  I have database which is 1 TB in size running under SQL 2008 R2 enterprise and configured for DB mirroring, each time I restart my server or service the Database is going for recovery for 45 minutes  or more, can someone advise me what is the reason and how to troubleshoot it


Thanks
0
ITMaster1979
Asked:
ITMaster1979
1 Solution
 
Tony303Commented:
Hey,

Have a look see here...

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/d08a0035-db93-4ef3-b357-d7825040107a/database-in-recovery-every-time-i-restart-sql-server-service?forum=sqldatabaseengine

Are your transaction log backups being done regularly? So you need to decrease the log backups interval? so there is less to recover at SQL Server Service startup?

T
0
 
David ToddSenior DBACommented:
Hi,

Have you looked at the article Tony suggested?

Or considered his advice to reduce the time between log backups? I've seen Brent Ozar blog about taking a transaction log backup every minute.

Regards
  David
0
 
BlueComputeCommented:
This is standard behaviour.  At startup the server will check all the transaction logs to ensure that the DB is in a consistent state.  As the other posters have said, back up the logs more frequently to reduce the amount that have to be processed at startup.
0
 
ITMaster1979Author Commented:
Thanks
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now