Differential database backups are usually faster to create than full database backups and reduce the number of transaction logs required to recover the database. SQL Server backups use a combination of full, differential, and transaction log backups (for the full or bulk-logged recovery model) to minimize recovery time. Follow SQL Server backup and restore optimization recommendations SQL Server data compression is not supported for SharePoint Server databases.įor more information about how backup compression affects performance in SQL Server, see Backup Compression (SQL Server). SharePoint Server supports SQL Server backup compression. Backup compression increases CPU usage and this can affect SQL Server concurrent operations. Backup compression was introduced in SQL Server 2008 Enterprise. In some circumstances, you can use compression to decrease the size of backups and the time to complete each backup.
For more information about types of backups, see Backup Overview (SQL Server). Although you can restore full backups faster than incremental backups, continuous incremental backups minimize data loss. Use incremental backups for large databases because you can make them quickly and maintain performance of the environment. Use incremental backups for large databases For more information, see Database types and descriptions in SharePoint Server.įor a graphical overview of the databases that support SharePoint Server 2016, see Quick reference guide: SharePoint Server 20 databases. For example, use multiple content databases for a web application instead of one large content database. Keep databases small to speed both backup and restore. Keep databases small for faster recovery times Consider staggering backups so that all databases are not backed up at the same time. A best practice is to always run incremental backups to safeguard against server failure. Typically, systems run 24 hours a day, seven days a week. 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.