Sluggish database after recovery

I, please i need urgent help! My production db went into recovery after server restart after we noticed that cache are not being flush and operations were dragging. Now we cannot even run a simple query on the db and even backup (diferential) are failing. This has now held up the entire industry for the past 9 hours! Please we need help or suggestions as to what to check or do. Thank you.

more ▼

asked Mar 10 at 02:59 AM in Default

avatar image


What version of SQL Server are you running? If the database is in recovery, the cache isn't the issue here. For some reason, SQL Server wasn't able to fully bring the database online after the restart. You won't be able to run any queries against the database if it is in a recovery state. Is there anything in the log file?

Mar 11 at 03:50 AM JohnM
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 10 at 02:59 AM

Seen: 18 times

Last Updated: Mar 11 at 03:50 AM

Copyright 2018 Redgate Software. Privacy Policy