Restoring bak files

Question

Restoring bak files

anjanasl

Valued Member

Points: 73
More actions
November 22, 2007 at 10:59 am

#184331

Hi I was have done a backup of my database yesterday.
My bak file has been overwritten again once.
When i tried restoring the database it is giving me the error
"System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Smo)".
I don hve two bak fileswith me.Please give me the solution if anyone knows.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

matt stockham SSCrazy Eights Points: 9942 More actions · Answer 1

Off the top of my head, the backup was written to multiple files but you are attempting to restore from only one of them.

Brandie Tarvin SSC Guru Points: 173045 More actions · Answer 2

anjanasl,

To expand on what Matt said, probably you're saving your backup to a previously created backup device which itself has two media families. Are you doing this through the GUI or through T-SQL?

If T-SQL, my advice is to create a brand new backup device and backup to there. If GUI, let us know the steps you're taking and what little radio buttons are clicked. This will help us trouble-shoot your issue better.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

chethan.chandra SSC Enthusiast Points: 118 More actions · Answer 3

i think the original backup wasnt overwritten, but was appended! and hence the error..

find out how u cud restore from backup in this case. do post the soln. (TIA for that)

btw.. u on SQL server 2005?

Brandie Tarvin SSC Guru Points: 173045 More actions · Answer 4

Chethan,

I doubt it's an appended backup issue. Media families usually refer to the media the backup is stored on. I.E., tape, UNC disk drive, local disk drive.

Unless you've seen this error before in regards to appended backups. If so, could you post more details on the issue?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Steve Jones - SSC Editor SSC Guru Points: 736160 More actions · Answer 5

What typically happens is you decide to make a new backup to a file and click "Add" and specify a new file in the backup dialog, it's the selected file, so you run the backup.

But if there's another file listed in the dialog, even if it's not selected, the backup will stripe across both files.

You need to find the other file. Or you can't restore. One of the backup files could be appended with other backups, but you have two files.

The .BAK extension is by convention. It's not required. You could have called the backups anything. Look for another file with the same timestamp.