Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 FILEGROUP backup. Move all Indexes or CI only?

Author  Topic 

sql-lover
Yak Posting Veteran

99 Posts

Posted - 2014-02-18 : 10:27:24
I'm about to move all the Indexes of an existing table to a different FileGroup and LUN. This is not due performance issues but in order to reduce backup time and backup space.

Should I move all Indexes to that FileGroup or only the Cluster Index? I know in case of a disaster recovery scenario, the whole table will be unavailable until I restore the CI, am I right about that?

Additional details: the table itself is about 200GB. Database size is 1.1 TB. We use RedGate backups.

Cheers ...
   

- Advertisement -