2/16/2023 0 Comments Fbackup mirrorThis is not very convenient for large databases. Every mirrored backup requires additional disk space. There are also some drawbacks, to using mirrored backups. It can even be used for split backup files. This feature supports all types of backups: full, differential, and transaction log backups. Mirrored database backup feature is supported in SQL Server 2005 Enterprise Edition and all later versions. Administrators usually store them on multiple backup devices, thus increasing the reliability of the backups, and greatly reducing the probability of data loss. Mirrored backups are actually identical copies of the same backup. Use backup mirroring – process where a database backup file is written to two or more (up to 3) different locations simultaneously. Perform multiple backup operations, but change the destination path for each operation There are a few ways to do this:Ĭreate a conventional backup file and use any file manager to copy the file to preferred locations To avoid this scenario, some administrators take multiple copies of their backup files, and store them on different backup devices. If the backup device fails, all of the backed up data might be lost. As the databases grow with time, the backups become larger, and backup devices less stable due to frequent read/write operations. Most of the time, opting for conventional backups should suffice, but in some cases, storing all backups on a single backup device may prove to be a bad idea. This plan usually includes multiple backup and restore operations. One of the most important tasks for any database administrator is to create a foolproof disaster recovery plan.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |