Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am trying to backup and restore my database which includes a filestream filegroup.

I backed up the database without the filestream filegroup and was interested to know what happens when you restore it. Inside the restore dialog nothing appeared in the 'Select backup sets to restore' list. This is not exactly surprising.

Then, I backed up the filestream data into a separate .bak file.

When I tried to restore them both together I got this message,

The media loaded on 'backup file' is formatted to support 1 media families, but 2 media families are expected according to the backup device specification.

  • What does that mean?
  • How can I backup filestream and database separately?
share|improve this question
add comment

1 Answer 1

You have to restore the database first with the norecovery switch, then restore the other file group. Then roll the transaction log forward then bring the database online.

This requires a minimum of three RESTORE DATABASE commands to do.

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.