Solved

SQL 2008 R2 Database going to recovery mode

Posted on 2014-03-14
5
433 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 12

Accepted Solution

by:
Tony303 earned 300 total points
ID: 39930982
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
ID: 39933555
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
ID: 39942113
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
ID: 40092292
Thanks
0

Featured Post

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
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.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

705 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