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.

This question already has an answer here:

I've got a database with 3 Filegroups and each filegroups own a single file, Filegroup names are Primary, SecondFG and ThirdFG. I want to backup ThirdFG separately each time without backing up the others. I've tried it in many ways but when I want to restore database filegroup backup I get the error for other Filegroups or files are not included in the backup file! but When I backup all FileGroups together there would be no problem, please guide me how to backup and restore single filegroup, by the way I've read all BOL and I couldn't solve my problem!

share|improve this question
add comment

migrated from stackoverflow.com Oct 14 '13 at 5:35

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

marked as duplicate by Kin, Paul White, Shawn Melton, RolandoMySQLDBA, Michael - sqlbot Dec 15 '13 at 7:45

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1 Answer

You can back up individual files and filegroups only when your database is using the full or bulk_logged recovery model, because you must apply log backups after you restore a file or filegroup; you can't make log backups of a database that's using the simple model.
Unlike full database and differential backups, a backup of a file or filegroup doesn't back up any portion of the transaction log. So, none of the transaction log is in a file or filegroup restore, and you still need to restore the log.
You can restore individual file or filegroup backups from a full database backup. Immediately before restoring an individual file or filegroup, you must back up the transaction log.
You must have an unbroken chain of log backups from the time the file or filegroup backup was made until the time the files or filegroups are restored.
After restoring a file or filegroup backup, you must restore all the transaction logs made between the time you backed up the file or filegroup and the time you restored it.
Restoring these interim transaction logs guarantees that the restored files are synchronized with the rest of the database.

share|improve this answer
    
I did every you said but the problem is when i select restore file and filegroups and select the backup file that contains one filegroup back up backup I get the error that other filegroups are not included into the backup file. –  Mohamad Ali Khourback Oct 14 '13 at 5:23
add comment

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