Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Restart a SQL Server 2008 database while in recovery

Posted on 2011-09-28
3
Medium Priority
?
243 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
[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
3 Comments
 
LVL 7

Accepted Solution

by:
mozcullu earned 1000 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

730 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