Skip or Include Database Files in Backups

To include or skip certain database files during the backup jobs, two registry keys are used. The type of database agent that you are using determines the use of these keys.

SkipDSAFiles Registry Key

The following agents use the SkipDSAFiles registry key:

• Agent for Domino
  • *.nsf
  • *.ntf
  • Mail.box

To use the SkipDSAFiles registry key, follow these steps:

1. When performing agent backups, navigate to the following registry key:
2. HKEY_LOCAL_MACHINE\SOFTWARE\Computer Associates\CA ARCserve Backup\ClientAgent\Parameters
2. Set the registry key to Value Name: SkipDSAFiles
3. Type: DWORD
4. Value: 0 to back up and 1 to skip

BackupDBFiles Registry Key

The following agents use the BackupDBFiles registry key:

• Agent for Microsoft SQL Server
• The list of data and transaction log files that are part of online databases is retrieved from Microsoft SQL Server at the start of a file backup. This list typically includes, but not exclusively:
  • *.ldf
  • *.mdf
  • *.ndf
• Except distmdl.mdf, distmdl.ldf, mssqlsystemresource.mdf, mssqlsystemresource.ldf, which cannot be skipped. Also, if a SQL Server instance is shut down, the database files will not be skipped.
• Exchange Database Level Agent/Exchange Document Level Agent
  • *.chk
  • *.log
  • Res1.log
  • Res2.log
  • *.edb
  • *.stm
• Agent for Oracle
  • *.dbf
  • Control*.*
  • Red*.log
  • Arc*.001

To use the BackupDBFiles registry key, follow these steps:

1. When performing agent backups, navigate to the following registry key:
2. HKEY_LOCAL_MACHINE\SOFTWARE\ComputerAssociates\CA ARCserveBackup\ClientAgent\Parameters
2. Set the registry key to Value Name: BackupDBFiles
3. Type: DWORD
4. Value: 0 to skip and 1 to back up (0 is default)