Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

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

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

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

3 Answers

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.

share|improve this answer
add comment

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

share|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
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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