![]() Is a placeholder that indicates that up to 64 backup devices may be specified in a comma-separated list. ![]() For more information about block size, see "BLOCKSIZE" later in this topic. In order to mirror backups to devices that have different sector sizes, the BLOCKSIZE parameter must be specified, and should be set to the highest sector size amongst all the target devices. If the MIRROR TO disk is formatted with a different sector size than the disk specified as the primary backup device, the backup command will fail. Also review the option for SQL Server backup to URL for S3-compatible object storage.įor MIRROR TO = DISK, BACKUP automatically determines the appropriate block size for disk devices based on the sector size of the disk.
0 Comments
Leave a Reply. |