?
Solved

Cancel SQL database restore

Posted on 2014-08-04
3
Medium Priority
?
209 Views
Last Modified: 2014-08-04
A database in SQL server is kept in restore state. How can I cancel it ? Tks
SQLRestore.png
0
Comment
Question by:AXISHK
  • 2
3 Comments
 
LVL 13

Expert Comment

by:PCIIain
ID: 40238467
RESTORE DATABASE <database name> WITH RECOVERY
0
 

Author Comment

by:AXISHK
ID: 40238482
"WITH RECOVERY" ... What does that command means ? Tks
0
 
LVL 13

Accepted Solution

by:
PCIIain earned 2000 total points
ID: 40238491
It tells SQL server there are no more backups coming on the chain, and it should come out of restore mode.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

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.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

839 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