Sunday, February 19, 2012

Backup / Restore databse with filegroups

I hope this is the right forum, if not sorry about that. On Friday I will be doing support with another orgnaization on a SQL 2000 cluster system. The database will be backed up , another team will do the major application upgrade, and I will be restoring the database back. From the SCN, there will be no database changes. I have been searchng for information on databse backups / filegroups.

My questions are:

1. The database has 3 filegroups, besides the primary. If I do a complete backup, will it also do the filegroups?

2. If not, how do I backup the filegroups?

3. Whne I resote the databse, how do I bring in the filegroups from the backup?

Any info or pointers to links is greatly appreciated. Have a good day.

Carl

Regular database backup will backup all the filegroups including primary unless you are taking the exclusive filegroup backup...

Check the Books online for Backup command...

When you restore full backup it will restore all the filegroups... if you are restoring to different drive you may need to use WITH MOVE option...

Again check Books Online for the correct syntax...

No comments:

Post a Comment