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.
| 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 ... |
|
|
|
|
|
FILEGROUP backup. Move all Indexes or CI only?