SQL Server Performance Forum – Threads Archive
Help with Database Restore Via Query Analyzer
Hello, I am trying to restore a database from a .BAK file. The following is my restore script:Restore filelistonly from disk=’D:MQkqdb.BAK’
RESTORE DATABASE Mein_Airways
FROM DISK = ‘D:MQmqdb.BAK’
WITH
MOVE ‘Mein Airways_Data’ TO ‘D:MQMein Airways_Data.MDF’,
MOVE ‘Mein Airways_Log’ TO ‘D:MQMein Airways_Log.LDF’
GO After I attempt to run the following script, I get the following error message:
quote:
Server: Msg 3270, Level 16, State 1, Line 2
An internal consistency error occurred. Contact Technical Support for assistance.
Server: Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
Server: Msg 3270, Level 16, State 1, Line 2
An internal consistency error occurred. Contact Technical Support for assistance.
Server: Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
Can anyone help me out in debugging this one? Danke,
Jamonakes
Try doing a verify: Restore verifyonly from disk=’D:MQkqdb.BAK’ Panic, Chaos, Disorder … my work here is done –unknown
Check whether this is the reason http://support.microsoft.com/Default.aspx?kbid=268481
]]>