Today, I would like to share this with others after I did.
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