Solved

Recovery State : Restore with NoRecovery

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
create index to c1, c2 and c3 9 65
PERFORMANCE OF SQL QUERY 13 65
SQL Encryption question 2 49
Record open by another user 6 50
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…
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 …

948 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

21 Experts available now in Live!

Get 1:1 Help Now