Define Backup Database Action Options

Use the Scheduler's Backup database Action to export a selected CSM database to a compressed Cherwell Archive Repository (.czar) file on a scheduled basis.

Define the following settings as they apply, and then select Save.

Setting	Description	Notes
Directory	Provide the directory name or select Browse to select a directory where database backup files are stored.	The directory must be available on the machine where the Scheduler runs. We recommend a UNC name.
File Name	Provide a file name for the database backup.
Rollover Files	Define the frequency of database backup files. Nightly: Uses the same file every time the backup runs. Weekly: Appends the day of the week to the backup files for a maximum of seven files. Monthly: Appends the day of the month to the backup files for a maximum of 31 files. Yearly: Appends the month and day to the backup files for a maximum of 365 files (366 for leap years).	If you don't roll over backup files, a new file is created for every database backup. The date is appended to the file name you entered (example: Cherwell20090305_093501.czar). For Weekly frequency, if you run a database backup every day of the week, there are seven files (one for each day of the week). If you run a backup every Monday, Wednesday and Friday, there are three files. The action uses these same files every week. For Monthly frequency, backup files are made for each day of the month. The action uses these same files every month. For Yearly frequency, backup files are made for each day of the year. The action uses these same files every year.
Export type	Export a single business object: Exports a selected Business Object to the database backup file. Export entire system: Exports the entire database to the backup file.
Content	Export a Single Business Object: Select the Business Object from the drop-down list. Exclude encrypted fields and protected stored values: Excludes encrypted fields and protected stored values from the export.	The options available in the Content section depend on the selected export type.
Content	Export entire system: Export all data: Exports all SQL Server tables (example: Field names and sizes) and data. Exclude attachments: Exports the Attachment table but not the attachment data within the table. Exclude automation data (events and scheduled actions, etc.): Exports the Events and Scheduler tables, but not the data within the tables. Exclude emails: Excludes emails from the export. Export table structure only: Exports all SQL Server tables without any data. Export structure and lookup table data: Exports SQL Server tables for all Major and Supporting Business Objects, as well as tables, and data for Lookup Objects (validation tables). Exclude encrypted fields and protected stored values: Excludes encrypted fields and protected stored values from the export.	Use Exclude attachments and Exclude automation data to create a .czar file to troubleshoot problems that are not related to Automation Processes or Scheduled Items. Use Export table structure only to create a .czar file that excludes your confidential company data. Use Export structure and lookup table data to create a .czar that excludes your confidential data but includes values from Lookup tables. Typically, Lookup tables don't contain confidential data, and you can use them to troubleshoot problems with validation and relationships.
Logging	Generate log file for this export (same location as export path): Generates a log file for the export and uses the same file path as the export.