Considerations for Very Large Databases
When it comes to backup and recovery, special consideration must be given to very large databases, which are known as VLDBs. A VLDB has the following special requirements:
• Storage—Size might dictate the use of tape backups over the network or a disk.
• Time—As your time to backup increases, the frequency of backups might have to be adjusted.
• Method—How you back up your database is affected by its size. Differential or file and filegroup backups might have to be implemented.
• Recovery—Partial database recovery, such as restoring a file or filegroup, might be required due to the prohibitive time required to restore the entire database.
When designing a VLDB, you must integrate your backup plan with ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
