question

Blackhawk-17 avatar image
Blackhawk-17 asked

Partition Backups

Is there a way to back up a partition in 2008? Or do you just align a partition with a filegroup?

I'm looking at multiple partitions on an "archive" filegroup but may want to back up a given partition to restore the data in a test environment.

More filegroups = more files = more management.

sql-server-2008backupfilegroupdatabase-files
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
CirqueDeSQLeil avatar image
CirqueDeSQLeil answered

Align it with a filegroup. Then perform the backup on the filegroup.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.