This is necessary to make sure that you can access the backups if the data or log disk fails. We recommend that a backup disk be a different disk than the database data and log disks. SQL Server management tools are very flexible at handling disk backup devices because they automatically generate a time-stamped name on the disk file. For information about how to use a remote disk, see Backing Up to a File on a Network Share, later in this topic. A backup disk can be a local disk on the server or a remote disk that is a shared network resource. Alternatively, you could use a hot-swappable disk drive that would let you transparently replace a full disk on the drive with an empty disk. The maximum size of a backup file is determined by the free disk space available on the disk device therefore, the appropriate size for a backup disk device depends on the size of your backups.Ī disk backup device could be a simple disk device, such as an ATA drive. If a disk file fills while a backup operation is appending a backup to the media set, the backup operation fails. SQL Server Backups can also be written to Azure Blob Storage in addition to disk or tape. If a backup requires multiple backup devices, the devices all must correspond to a single type of device (disk or tape). A backup can be written to from 1 to 64 backup devices. For more information about media sets, see Media Sets, Media Families, and Backup Sets (SQL Server).Įither a tape drive or a disk file that is provided by the operating system. A backup file is a regular operating system file.Īn ordered collection of backup media, tapes or disk files, that uses a fixed type and number of backup devices. Terms and definitionsĪ hard disk or other disk storage media that contains one or more backup files. Backups on a set of one or more backup devices compose a single media set. This physical backup device is initialized when the first backup in a media set is written to it. During a backup operation on a SQL Server database, the backed up data (the backup) is written to a physical backup device.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |