Suppose you are restoring a database using multiple backup files, you would use the WITH NORECOVERY option for each backup file except the last one. If 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.
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!!!
