SQL Sever Error 3154: The backup set holds a backup of a database other than the existing database.
Test Environment: MS Server 2008
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
USE master GO -- Database to restore : DJ_ADMIN -- Resore With: DJ_ADMIN_Latest.bak -- Backup existing database's to : DJ_ADMIN_Old.bak;DJ_ADMIN_Old_Log.bak -- Database to restore : DJ_ADMIN ALTER DATABASE DJ_ADMIN SET SINGLE_USER WITH ROLLBACK IMMEDIATE RESTORE DATABASE DJ_ADMIN FROM DISK = 'C:\Backups\DJ_ADMIN_Latest.bak' WITH MOVE 'DJ_ADMIN' TO 'C:\Backups\DJ_ADMIN_Old.mdf', MOVE 'DJ_ADMIN_Log' TO 'C:\Backups\DJ_ADMIN_Old_Log.ldf', REPLACE |