SQL SERVER – Database in RESTORING State for Long Time

Today, I would like to share this with others after I did. Restoring

Non recovery sate to recover the database. That means database is no recovery mode. And may be you have simalar database clone and restoring stage conflit, so that user can restore log file till the database is no revovery mode.
Note: To understand how the backup restores timeline works read Backup Timeline and Understanding of Database Restore Process in Full Recovery Model.

Following ways to recover the database.

1) Recover the database manually with following command.

RESTORE DATABASE database_name WITH RECOVERY
2) Recover the database with the last log file.

RESTORE LOG database_name FROM backup_device WITH RECOVERY

3) Recover the database when bak is restored

RESTORE DATABASE database_name FROM backup_device WITH RECOVERY



Leave a Reply

Your email address will not be published. Required fields are marked *