Solved

Recovery State : Restore with NoRecovery

Posted on 2007-12-04
1
2,377 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
Comment Utility
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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

743 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