The backup set holds a backup of a database other than the existing SQL Server 2012

TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore failed for Server 'VMI395580\MSSQLSERVER2012'.  (Microsoft.SqlServer.SmoExtended)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).120210-1917+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

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 'NDHN' database.
RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.2100&EvtSrc=MSSQLServer&EvtID=3154&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Solution: 
1- Right click on database → Restore Database...

2- Check Device as source and locate .bak (or zipped .bak) file

3- In the left pane click on options Overwrite the existing database (WITH REPLACE) and Preserve the replication setting (WITH KEEP_REPLICATION)



Reactions

Post a Comment

0 Comments