Friday, January 22, 2010

How To Convert Ldf File Convert Backup File Generated From SQL Server To MDF And LDF Files?

Convert backup file generated from SQL server to MDF and LDF files? - how to convert ldf 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 ... !

4 comments:

StorageCraft said...

Thanks for suggesting the method for connecting the file to the server. It has solved out almost 90 % of my problem. The rest 10% i can mange myself.

Smutty said...

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

Smutty said...

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

Julio M said...

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