Backing Up Data › Files and Objects that CA ARCserve Backup Does Not Back Up › Skip or Include Database Files in Backups

Skip or Include Database Files in Backups

Effective with CA ARCserve Backup r12, there are two registry keys used to include or skip certain database files during backup jobs. Use of these keys is determined by the type of database agent you are using.

SkipDSAFiles Registry Key

The following agents use the SkipDSAFiles registry key:

• Agent for Oracle, Agent for SAP R/3 (r12.1 and earlier versions)
  • *.dbf
  • Control*.*
  • Red*.log
  • Arc*.001
• Agent for Domino
  • *.nsf
  • *.ntf
  • Mail.box
• Agent for Sybase
  • Physical file of Master device
  • Physical file of non-Master device
  • Physical file of Mirror device
• Agent for Informix
  • *.000

To use the SkipDSAFiles registry key

1. When performing agent backups:

   HKEY_LOCAL_MACHINE\SOFTWARE\Computer Associates\CA ARCserve Backup\ClientAgent\Parameters

2. Set the registry key to Value Name: SkipDSAFiles

   Type: DWORD

   Value: 0 to back up and 1 to skip

BackupDBFiles Registry Key

The following agents use the BackupDBFiles registry key:

• Agent for Microsoft SQL

  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

  Note: The Exchange Brick Level Agent is no longer supported.

To use the BackupDBFiles registry key

1. When performing agent backups:

   HKEY_LOCAL_MACHINE\SOFTWARE\ComputerAssociates\CA ARCserveBackup\ClientAgent\Parameters

2. Set the registry key to Value Name: BackupDBFiles

   Type: DWORD

   Value: 0 to skip and 1 to back up (0 is default)