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

Skip or Include Database Files in Backups

Effective with 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 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 (r12.5 or later)
  • *.dbf
  • Control*.*
  • Red*.log
  • Arc*.001

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)