Monday, April 5, 2010

Msg 62301, Level 18, State 1, Line 0

Error
Msg 62301, Level 18, State 1, Line 0
SQL Server has returned a failure message to LiteSpeed for SQL Server which has prevented the operation from succeeding.
The following message is not a LiteSpeed for SQL Server message. Please refer to SQL Server books online or Microsoft technical support for a solution:
RESTORE DATABASE is terminating abnormally.
The backup set holds a backup of a database other than the existing 'Testing' database.

Solution
You are restoring different database backup than the previously restored database.
Check\confirm database name and server name using following script
RESTORE DATABASE HEADERONLY FROM DISK=N'Database_Backup_File_Path'

No comments:

Post a Comment