As part of moving the SCOM 2012 R2 Operational Database, we need to restore the it into new database server. However, we may get the following error, while restore database in Management studio:
"SQL SERVER – FIX : Error 3154: The backup set holds a backup of a database other than the existing database"
To fix the error:
"SQL SERVER – FIX : Error 3154: The backup set holds a backup of a database other than the existing database"
To fix the error:
1) Use WITH REPLACE while using the RESTORE command.
2) Delete the older database which is conflicting and restore again using RESTORE command.
3) Sample Example :
RESTORE DATABASE OperationsManager
FROM DISK = 'E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\OperationsManager.bak'
WITH REPLACE
