Solved

SQL 2008 R2 Database going to recovery mode

Posted on 2014-03-14
5
383 Views
Last Modified: 2014-05-26
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
Comment
Question by:ITMaster1979
5 Comments
 
LVL 12

Accepted Solution

by:
Tony303 earned 300 total points
Comment Utility
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
 
LVL 35

Expert Comment

by:David Todd
Comment Utility
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
 
LVL 14

Expert Comment

by:BlueCompute
Comment Utility
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
 
LVL 1

Author Comment

by:ITMaster1979
Comment Utility
Thanks
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now