Tuesday, October 16, 2007

Very large database--use multiple filegroups --why

If you have a history database, which has 3GB, to fully back up this database takes long time. It is unachievable for every day full backup. You could create multiple filegroups for the database and create partitions for them. You can fully back up the current-used filegroup daily. Monthly create a full backup of database.