Recently I faced an issue when trying to restore a bak file .
![](https://i0.wp.com/365community.online/wp-content/uploads/2023/06/bak-file-restore-error-The-backup-set-holds-a.png?resize=563%2C444&ssl=1)
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
More About This Author
Array
Finance & Operations25 July 2024Logic apps Standard – Parameterization
Finance & Operations24 July 2024Extracting Subfolder Details from Parent Directory using logic apps
Finance & Operations7 June 2024GA of D365F&O 10.0.40
Finance & Operations30 May 2024Webhook validation handshake failed – Azure Event Grid