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

SharePoint Close methods for SP Long Operations and Redirect Error Page

Example 1 : protected override void OnClick(EventArgs e) { try{ using (SPLongOperation longOp = new SPLongOperation(this.Page)) { longOp.LeadingHTML = "Long Operation Title"; longOp.TrailingHTML = "This may take few seconds."; longOp.Begin(); //-------------------------- //code for long running operation is here //--------------------- EndOperation(longOp); } } catch (ThreadAbortException) { /* Thrown when redirected */} catch (Exception ex) { SPUtility.TransferToErrorPage(ex.ToString()); } } protected void EndOperation(SPLongOperation operation) { HttpContext context = HttpContext.Current; if (context.Request.QueryString["IsDlg"] != null) { context.Response.Write("<script type='text/javascript'>window.frameElement.commitPopup();</script>"); context.Response.Flush(); context.Response.End(); } else { string url = SPContext.Curre...
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