SQL Server Backups

Supported SQL Server databases can be backed up using either File backup or Block backup.

See also. For the latest system compatibility details regarding supported hardware, file systems, applications, operating systems, and service packs, see the Compatibility Guide.

DPX performs base, incremental, and differential backups of SQL Server databases. Following is the default behavior:

  • In a base backup of a SQL Server database, DPX backs up the entire database. This includes all tables and the uncommitted transactions from the transaction log, which are needed to roll back the database to a consistent state upon restore.

  • In an incremental backup of a SQL Server database, DPX backs up all transaction logs since the last successful base or incremental backup of that database.

  • Transaction logs for databases using full recovery model are only truncated during an incremental backup.

  • A differential backup of a SQL Server database is accomplished by using the WITH DIFFERENTIAL option in the Transact-SQL BACKUP command. Thus DPX backs up the relevant parts of the database which include all “extents” that have changed since the last successful base backup and the uncommitted transactions from the transaction log.

SQL Server does not allow incremental or differential backup of the master database. Because of this restriction, when running an incremental or differential backup of an entire SQL Server, a base backup will automatically be performed on the master database.

Related Topics:

Last updated