Tuesday, July 18, 2023

SQL Server Issue - SQL Server Database struck in Recovery Mode

Scenario: We can not restore the same with latest backup because the DB is critical and there is no latest backup to restore
.
Following are the suggestions to handle this situation:
1) If you are able to see .Mdf file of the database then copy this mdf in other folder.
2) create database in some other instance with this mdf file.
3) Review this new database & take backup.
4) Restore it in your required instance.
5) Other option is to restore the database to the nearest point in time.

No comments:

Post a Comment