November 21, 2009 at 10:56 am
Ok I am at the point when I need to offspring my DB into multiple filegroups (with table partitions on each of them).
I used to only trust full backups which now take a lot of time. So my questions regarding backups of the Db with multiple file groups are
1. will a full backup with multiple FGs generate multiple files (as many as FGs)?
2. is there a way to only backup full FGs that have been changed?
3. is there any way to recover a DB (or what is left of it) if a single FG becomes corrupt?
4. is there a way to restore a DB with a missing FG?
5. do I need to worry about safety of master or any other system DB to successfully restore a DB with multiple FGs?
Remember that partitions of a single table will be on those FGs.
Thx.
November 27, 2009 at 3:04 pm
Please review these SQL Server Book Online topics
SQL Server 7.0 Books Online topics:
"Physical Database Files and Filegroups"
"Using Files and Filegroups"
"Creating Filegroups"
"Creating File or Filegroup Backups"
"Using File or Filegroup Backups"
"Restoring File or Filegroup Backups"
"File and Filegroup Backup and Restore"
SQL Server 2000 Books Online topics:
"Physical Database Files and Filegroups"
"Using Files and Filegroups"
"Creating Filegroups"
"Using File Backups"
"Files and Filegroups"
"Backing up and Restoring Databases"
"Partial Database Restore Operations"
"Backing up Selected Portions of a Database"
SQL Server 2005 Books Online topics:
"Physical Database Files and Filegroups"
"Using Files and Filegroups"
"Creating Filegroups"
"File and Filegroup Backups"
"Designing Files and Filegroups"
"Backing up and Restoring Databases"
"Piecemeal Restore Scenario (Full Recovery Model)"
"Backing up Selected Portions of a Database"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply