Convert backup file generated from SQL server to MDF and LDF files?
i backuped a database using Enterprise manager and saved the backup file into DISK wiz name “MyBackup.bak” ..
I want to generate from this backup file two files in MDF and LDF files .Because i can’t restore the “MyBackup.bak” again , I got an error “The media set for database ‘MyDB’ has 2 family members but only 1 are provided. All members must be provided.”.
Please any one can help me … !!!!
The solution is to restore your database from the backup file.
The error means the backup was done using more than one device or backup file and you are trying to restore using just one. You need to provide all the backup devices, files in your restore command, e.g.:
RESTORE DATABASE YourDatabase
FROM
DISK = ‘C:YourDB1.BAK’, DISK = ‘C:YourDB2.BAK’
Thank You
hahah yup, there’s a difference between attaching database files and restoring a backup, which is what you have. restore with the Enterprise manager, it has a wizard for it, right click the database and click Restore.
Cheers Mr. Bean!