Database is "restoring" after RESTORE

1
votes

I try to restore a database from .bak file created by sql management studio 2012.

 RESTORE DATABASE db
   FROM DISK = 'd:\abc.bak'
   WITH NORECOVERY,
   MOVE 'abc' TO 'D:\My Data\db_Data.mdf', 
   MOVE 'abc_log' TO 'd:\My data\db_Log.ldf',
   REPLACE
GO

it went through but then cannot open the database, always has Restoring... status on the name.

What's going on here?

2
sql-servertsql

2 Answers

1
votes

The database remains in recovery, waiting for additional log restores. Use WITH RECOVERY to complete the restore.

1
votes

You need to use the WITH RECOVERY option, with your database RESTORE command, to bring your database online from a recovery mode as part of the restore process.

You can also use the overwrite option WITH REPLACE

RESTORE DATABASE db
   FROM DISK = 'd:\abc.bak'
   WITH REPLACE, RECOVERY
   MOVE 'abc' TO 'D:\My Data\db_Data.mdf', 
   MOVE 'abc_log' TO 'd:\My data\db_Log.ldf'
GO

This is the most guaranteed way to restore a database.