File checkpointing

Use file checkpointing if you need to perform a large backup and want to save completed work in case the operation fails before it completes. When file checkpointing is enabled, the database or filegroup is divided into file sets that are backed up as separate units. The following batch file command initiates file checkpointing:

MAXRESTARTS integer

The backup operation is split into the number of operations specified by the integer value, unless the total number of files comprising the database or filegroup operation is less than that value. In this case, the number of separate operations is the number of files.

File checkpointing is available for databases and filegroups that are backed up as streams or with the snapshot option. However, the following restrictions exist:

When you use file checkpointing for backing up a full database, NetBackup for SQL Server automatically splits the database into fileset components. Recovering the database from components requires a restore of the transaction log. NetBackup for SQL Server automatically includes a backup log directive in the generated batch file when you choose file checkpointing from the backup dialog box.