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.bak'
WITH REPLACE

Comments

Post a Comment

Popular posts from this blog

How to remove app from SharePoint 2013/2016

I have installed an SharePoint App for creating surveys but when try to uninstall / remove it from the site it shows exception message " sorry we couldn't remove the app ". Solution: I have used following Power-Shell commands to install/remove app successfully  $instances = Get-SPAppInstance -Web <URL> $instance = $instances | where {$_.Title -eq '<app_title>'}   Uninstall-SPAppInstance -Identity $instance
Read more

The model backing the context has changed since the database was created. Consider using Code First Migrations to update the database

One way to resolve this error is to use Code First Migrations to update the database schema to match the new model. To do this, you can use the following steps: Open the Package Manager Console in Visual Studio by going to Tools -> NuGet Package Manager -> Package Manager Console. In the Package Manager Console, run the command Enable-Migrations to enable migrations in the project. Run the command Add-Migration <migration-name> to create a new migration for the changes you made to the model. Run the command Update-Database to apply the changes to the database.
Read more