السبت، 19 مايو 2012

Fixing Error : The backup set holds a backup of database other than the existing database.

Step 1: Open your Microsoft SQL Server Management Studio Express and connect to your database.
Step 2: Select the database >> Right-click >> Tasks >> Restore >> Database [as shown in the image below

Restore MS SQL Server 2008 Database

Selecting Options within Restore Database dialog box.
 Specifying correct path to the mdf and log file for the database.
 Checking Overwrite the existing database option.

0 التعليقات: