Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Wednesday, 8 October 2014

The backup set holds a backup of a database other than the existing

The backup set holds a backup of a database other than the existing


Causes:
Do not create blank database or dummy name database and restore from backupfile is diffrent then u can get above error

To avoid:

Do not create any empty or dummy name database

Just right click from databases and click Restore Database then type the name as u want and select backupfile location then choose overwrite option then click ok.








Thats it.