Wednesday, June 1, 2011

Error 3154: The backup set holds a backup of a database other than the existing 'xx' database

If you are getting this error than restore database using script

Use Master
RESTORE DATABASE ihkdb01
FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\ihkdb01.bak'
WITH MOVE 'ihkdb01' TO 'D:\SQLServerRepository\ihkdb01.mdf',
MOVE 'ihkdb01_Log' TO 'D:\SQLServerRepository\ihkdb01_log.ldf',
REPLACE

No comments: