Convert backup file generated from SQL server to MDF and LDF files? - convert .bak file to .mdf file
I drove a database using the Enterprise Admin and saved the backup disk wiz named MyBackup.bak "..
I would like to generate from this file, copy both files into MDF and LDF. Since you did not understand how to restore the "MyBackup.bak" again, I get an error "for the media database mydb 'set 2 family members, but are intended only 1st All members must pay" ..
If anyone can help me ... !
Thursday, February 4, 2010
Convert .bak File To .mdf File Convert Backup File Generated From SQL Server To MDF And LDF Files?
Subscribe to:
Post Comments (Atom)
2 comments:
The solution is to restore your database from backup file.
The error means that the backup was made that more than one device or file backup and restore is an attempt to use. You must provide all the backup devices to recover your files in the command, for example:
RESTORE DATABASE YourDatabase
OF
DISK = 'C: \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ YourDB1.BAK', DISK = 'C: \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ YourDB2.BAK "
Thanks
hahah yup, there's a difference between database files to attach and restore a backup, that is what we have. Restoration of the head of the company that Click to take a wizard to this, on the right side of the database and click Restore has.
Cheers Mister Bean!
Post a Comment