[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Recovery State : Restore with NoRecovery

Posted on 2007-12-04
1
Medium Priority
?
2,388 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 2000 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

607 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