SQL SERVER – FIX : Error 3154: The backup set holds a backup of a database other than the existing database
ERROR: TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore failed for Server 'DBSERVER'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00& EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476 An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) The backup set holds a backup of a database other than the existing 'DB' database. RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3154&LinkId=20476 SOLUTION Create a database and then try this command: RESTORE DATABASE AdventureWorks FROM DISK = 'C:\ BackupAdventureworks