Tuesday, September 2, 2014

How to Recover a database that is in the "restoring" state!!!

Suppose you are restoring a database using multiple backup files, you would use the WITH NORECOVERY option for each backup file except the last oneIf you will go through the above steps your database will be recovered and will be usable.

But suppose in last backup file you have used WITH NORECOVERY option instead of WITH RECOVERY. In this situation your database will go into restoring state as below:


Now let see how to recover it without restoring additional backups. To do the same you can execute below command to bring the database online.

RESTORE DATABASE <Database_Name> WITH RECOVERY 

As per screen shot the database name is "Recover" so you will have to execute command as below:

RESTORE DATABASE Recover WITH RECOVERY 

After this your database will be available for use.



Thanks For Reading this Post!!!

No comments:

Post a Comment