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

Restart a SQL Server 2008 database while in recovery

If I restart a SQL Server 2008 database server while  a database is in recovery, will it continue recovering where it left off when the service starts back up?
1 Solution
no. it will fail as the process will be killed
MISquaredAuthor Commented:
Great, I wanted a yes or no, and I got one. The idea is that the recovery is taking so long due to memory constraints so we were going to shutdown, add more memory, and hope that the recovery will pick up where it left off when restarted. I figured the answer would be no, but had to check the option.

No any manual process is available for sql database recovery. The sql database recovery is only possible via tool. You have to download the tool and install it into the computer after installing you can follow the steps of the tool and then your MDF file will be repaired. The sql database recovery is very important for us.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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