How do pdm_backup and pdm_restore work with the MDB in r11.2?
Article ID: 53600
CA IT Asset ManagerCA Software Asset Manager (CA SAM)ASSET PORTFOLIO MGMT- SERVERSUPPORT AUTOMATION- SERVERCA Service Desk Manager - Unified Self ServiceCA Service Desk ManagerCA Service Management - Asset Portfolio ManagementCA Service Management - Service Desk Manager
Pdm_backup and restore work against the MDB but only backs up and restores Service Desk related tables. Both commands are utilized in the same way as in previous versions of Service Desk. The following data is backed up by pdm_backup in r11:
All Service Desk Tables
ca common tables that Service Desk utilizes such as ca_contact, ca_owned_resource, etc.*
Options Manager settings
All Keyword Search/Knowledge Tools Tables
Custom form groups and forms
However pdm_backup does not backup the following data:
Attachments- Attachment links are backed up but not actual files. Customers need to manually back up directories under site/attachments
The entire MDB is not backed up, only Service Desk related tables
Service Intelligence- Si_ tables are not backed up.
CA Workflow- Workflows and settings are not backed up. CA Workflow process definitions can be backed up using XML export tool from Workflow IDE.
Pdm_restore works differently than in previous versions because it now takes into account common tables in the MDB that Service Desk users. It is important to note that because of data constraints on the MDB several sql commands need to be run before doing a pdm_restore. Please see the "Backing up the Database" section in the Administrator guide. The following are key points in regards to what pdm_restore does in r11:
CA Common Tables
Common Tables are NOT cleared
Primary key is UUID and restore will only add non-existent UUIDs
No duplicate UUIDs will be created
Objects with duplicate names will be created if they have different UUIDs
Does NOT clear or restore Ca_asset or other discovered asset tables