(Restoring...) question

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » (Restoring...) question

(Restoring...) question

Rate Topic

Display Mode

Topic Options

Author

Message

MickyD

Posted Saturday, January 05, 2013 3:20 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 8:54 AM
Points: 166, Visits: 750

Hi everyone.
Could anyone help with this one.
A database has incorrectly been restored with (RESTORE WITH NORECOVERY) configured, therefore database is in (restoring) state post completion of restore.

is the only way to bring the database back on line is to do another restore with correct recovery option configured ?

Backup is coming from Veritas backup.

cheers for any tips or advice.

Post #1403282

GilaMonster

Posted Saturday, January 05, 2013 3:27 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 2:45 PM
Points: 37,635, Visits: 29,885

Run

RESTORE DATABASE <database name> WITH RECOVERY

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1403285

MickyD

Posted Sunday, January 06, 2013 2:25 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 8:54 AM
Points: 166, Visits: 750

Thank you

Post #1403317

Jeff Moden

Posted Sunday, January 06, 2013 11:26 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 6:33 PM
Points: 32,889, Visits: 26,757

MickyD (1/5/2013)

is the only way to bring the database back on line is to do another restore with correct recovery option configured ?

The answer is "yes and no". The command to run is the one that Gail posted with the understanding that if the database has already been restored and is just waiting for the final recovery step, then it won't actually go through another full restore. All it will do is go through the final recovery step (which usually takes less than a second on most databases) to bring the database on line.

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1403418

« Prev Topic | Next Topic »

Permissions