November 29, 2011 at 6:16 am
Hi All,
Is there a way I can take backup of all the unused filegroups. e.g. I have switched all the Septemner data to a new backup table. My main table does not contain data for september anymore. So is there a way I can take backup of all the september filegroups. Is it possible without taking the backup of the entire DB.
Thanks,
Swaroop
November 29, 2011 at 6:21 am
Try Backing Up Specific Files or Filegroups
BACKUP DATABASE { database_name | @database_name_var }
<file_or_filegroup> [ ,...n ]
TO <backup_device> [ ,...n ]
[ <MIRROR TO clause> ] [ next-mirror-to ]
[ WITH { DIFFERENTIAL | <general_WITH_options> [ ,...n ] } ]
[;]
OR Creating a Partial Backup
BACKUP DATABASE { database_name | @database_name_var }
READ_WRITE_FILEGROUPS [ , <read_only_filegroup> [ ,...n ] ]
TO <backup_device> [ ,...n ]
[ <MIRROR TO clause> ] [ next-mirror-to ]
[ WITH { DIFFERENTIAL | <general_WITH_options> [ ,...n ] } ]
[;]
November 29, 2011 at 7:23 am
If I take backup of the filegroups and after taking backup I will do a merge on the table for September. How to restore after that.
November 29, 2011 at 7:31 am
swaroop.sahoo (11/29/2011)
If I take backup of the filegroups and after taking backup I will do a merge on the table for September. How to restore after that.
If you ask me I don't prefer partial or filegroup backups. Their backup / restore is bit complex. I would suggest you to read following, before implementing anything.
Restore and Recovery Overview (SQL Server)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply