Solved

Recovery State : Restore with NoRecovery

Posted on 2007-12-04
1
2,381 Views
Last Modified: 2008-06-18
MS SQL 2005 DB Restoration

If I select "Leave the database nonoperational (Restore with NoRecovery) option",can I open DB at least for read-only?
I understand I can restore additional transaction logs with this restoration.
But what if I select this option and don't apply any more t-log restoration?

I gues my question is what "nonoperation" means.

Thank you for your time
0
Comment
Question by:JOSHUABT
1 Comment
 
LVL 11

Accepted Solution

by:
Goodangel Matope earned 500 total points
ID: 20409837
leaving the database non-operational means that  you are doing a partial restore, and that you want to perform additional actions before putting the database online. Uncommitted transactions will be not be rolled back, and additional transaction logs can be restored to increase the 'completeness' for the data
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
What is the best way to calculate hours worked 5 70
SQL Select - Finding chars in a column 2 61
Grid querry results 41 78
How can i use WITH CTE for checking exist value? 3 33
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
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.
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

777 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