up vote 0 down vote favorite
share [g+] share [fb]

Backup a simple model database

When restore to another server's database, path is correct and tick overwrite existing database and change to simple model in options

Error occurs

The media set has 2 media families but only 1 are provided

link|improve this question
Have you read this already? – Martin Smith Mar 23 '11 at 12:14
feedback

migrated from stackoverflow.com Mar 25 '11 at 7:27

This question came from our site for professional and enthusiast programmers.

3 Answers

up vote 1 down vote

What version of SQL you are using? Are you trying to restore system database -MODEL or an user database? Are you restoring using GUI or TSQL?

You might try running RESTORE FILELISTONLY to see the contents of the backup file.

link|improve this answer
feedback
up vote 0 down vote

Looks like the backup consist of two files, but you restore only one of them.

link|improve this answer
thanks, solved, the list have more than two files, will split into two files, i misunderstand highlight one file is to restore one file – Super G Mar 26 '11 at 10:08
feedback
up vote 0 down vote

I assume that the backup you took was a Full backup rather than a differential.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.