December 21, 2003 at 9:54 pm
Dear friends
Suppose I create a table with data pages, clustered index and nonclustered indexes on three different files in three differnt filegroups(one filegroup contains one file). In such a scenario, if I take filegroup backup it could result in inconsistency. so in such a scenario I may have to take full database / differential backup. This is ok if the database is small. But if your database is very large(VLDB) and if you want to put indexes and data in 3 differnt files, what has to be the backup strategy.
December 22, 2003 at 7:28 am
If you want to use file groups so that you can backup parts of your database at different intervals, you do need to backup your tables and indexes at the same time. The usual strategy is to put data that doesn't change that often in a sperate filegroup. Of course in most databases, that constitutes a small portion of the data.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply