Solved

Restart a SQL Server 2008 database while in recovery

Posted on 2011-09-28
3
237 Views
Last Modified: 2014-04-14
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?
0
Comment
Question by:MISquared
3 Comments
 
LVL 7

Accepted Solution

by:
mozcullu earned 250 total points
ID: 36717705
no. it will fail as the process will be killed
0
 
LVL 2

Author Closing Comment

by:MISquared
ID: 36717860
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.

Thanks!
0
 

Expert Comment

by:johnbell394
ID: 39998770
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.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In this article I will describe the Backup & Restore 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.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

813 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

11 Experts available now in Live!

Get 1:1 Help Now