SQL Server restore problem

Question

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

Have you read this already?
– Martin Smith
Mar 23, 2011 at 12:14 — Martin Smith, Mar 23, 2011 at 12:14

sqlmastersqlmaster · Accepted Answer · 2011-03-23 12:04:25Z

1

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.

answered Mar 23, 2011 at 12:04

sqlmaster

Add a comment |

ceth · Accepted Answer · 2011-03-23 11:54:08Z

0

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

answered Mar 23, 2011 at 11:54

ceth

5461 gold badge7 silver badges16 bronze badges

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, 2011 at 10:08

Add a comment |

Peter Schofield · Accepted Answer · 2011-03-23 11:55:31Z

0

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

answered Mar 23, 2011 at 11:55

Peter Schofield

1,6499 silver badges11 bronze badges

Add a comment |

3 Answers 3