hi experts,
i am trying to restore database in sql 2017 from SSMS i have created a new database and trying to restore dabase from bak file from my device now when right click on database task,restore,files and files group then it will open window in general-> where i add my bak file and in option ->i selected (with replace ) now when i click ok it will give me error as
please help .thanks in advance
Answers
1) You can Restore the database without first creating an empty database
2) Use "Overwrite the existing database" at the Restore Options
Source Posts:
https://stackoverflow.com/questions/10204480/the-backup-set-holds-a-backup-of-a-database-other-than-the-existing
https://blog.sqlauthority.com/2013/11/23/sql-server-fix-error-3154-the-backup-set-holds-a-backup-of-a-database-other-than-the-existing-database-ssms/
Arhontis
https://forum.mibuso.com/search