question

shamim007 avatar image
shamim007 asked

RESTORE DATABASE is terminating abnormally.

I used below query to restore my Database .now i am getting error . Msg 5052, Level 16, State 1, Line 4 ALTER DATABASE is not permitted while a database is in the Restoring state. Msg 5069, Level 16, State 1, Line 4 ALTER DATABASE statement failed. 5 percent processed. 10 percent processed. 15 percent processed. 20 percent processed. 25 percent processed. 30 percent processed. 35 percent processed. 40 percent processed. 45 percent processed. 50 percent processed. 55 percent processed. 60 percent processed. Msg 3183, Level 16, State 2, Line 10 RESTORE detected an error on page (0:0) in database "NetDB" as read from the backup set. Msg 3013, Level 16, State 1, Line 10 RESTORE DATABASE is terminating abnormally. " USE master go ALTER DATABASE NetDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO RESTORE DATABASE [NetDB] FROM DISK = 'E:\backup\full\NetDB_backup_20161218.bak' WITH RECOVERY, REPLACE, MOVE 'NetDB_Dat' TO 'L:\Data\NetDB_Dat.mdf', MOVE 'NetDB_log' TO 'L:\Data\NetDB_log.ldf', MOVE 'NetDB_F2' TO 'L:\Data\NetDb_F2.ndf', STATS = 5 GO what is the solution ?
sql-server-2008restore
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sp_lock avatar image
sp_lock answered
Have you tried to restore with `VERIFYONLY` ? You could also try to restore the backup with the `CONTINUE_AFTER_ERROR` option. Once you have done this run DBCC CHECKDB See [here][1] for the RESTORE documentation and [here][2] for RESTORE VERIFYONLY [1]: https://msdn.microsoft.com/en-us/library/ms186858.aspx [2]: https://msdn.microsoft.com/en-us/library/ms188902.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.