bak file restore error : The backup set holds a backup of a database other than the existing ‘xxx’ database

Recently I faced an issue when trying to restore a bak file .

Though the option ‘Overwrite the existing database (with Replace)’ was selected during restore process, error was not resolved.

Instead of executing the ‘Restore’ from database level, I tried to do it from query editor . This helped me to get more insight on the issue.

RESTORE DATABASE NewDatabase
FROM DISK =...

Continue Reading AnithaEswaran’s Article on their blog

bak file restore error : The backup set holds a backup of a database other than the existing ‘xxx’ database

Recently I faced an issue when trying to restore a bak file . Though the option ‘Overwrite the existing database (with Replace)’ was selected during restore process, error was not resolved. Instead of executing the ‘Restore’ from database level, I tried to do it from query editor .

Blog Syndicated with AnithaEswaran’s Permission