![]() ![]() Avoid processing conflictsĭo not run backup jobs during times when users need access to the system. For more information, see Monitor Disk Usage. This is typical and should not be considered a problem. Therefore, you might see disk queuing, which can result in greater than usual latency for I/O requests. For more information, see Define a Logical Backup Device for a Disk File (SQL Server).īy design, most backup jobs consume all available I/O resources to complete the job. To avoid I/O bottlenecks, perform the main backup to a separate disk from the disk running SQL Servers 2017 RTM, 2016, 2014, 2012, or 2008 R2 with Service Pack 1 (SP1). For more information, see "Backing Up to a File on a Network Share" in Backup Devices (SQL Server). Because network backups are subject to network errors, verify the backup action after it finishes. If you cannot back up to local drives, use network drives with similar latency. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |