How to recover databases Restore Status on SQL Server
You can perform a RESTORE DATABASE SampleDB WITH RECOVERY command to bring the database online so that
users can access it if it is still in the restoring state and you need to
repair it without restoring additional backups.
A. Select RESTORE WITH RECOVERY in Options
using sql scripts
RESTORE DATABASE SampleDB WITH RECOVERY
GO
B. Select RESTORE WITH RECOVERY in Options
using SSMS
1. Launch SSMS and connect to your instance, right-click the SQL Server
database in restoring state, select Tasks > Restore > Database…
2. Turn to Options page in the right tab, select RESTORE WITH RECOVERY in
Recovery state section.
3. Then click OK.
0 Comments