MS SQL Server – backup Error 3154

SQL Sever Error 3154: The backup set holds a backup of a database other than the existing database.

Test Environment: MS Server 2008

Transact-SQL
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