CA Service Management - 14.1 - Backup and Restore  - database - MS SQL - How to do:

Document created by TMACUL Champion on Jul 3, 2015Last modified by TMACUL Champion on Jun 16, 2017
Version 4Show Document
  • View in full screen mode

-----------------------------------------------------------------------------------------------------------------------------------------------------------

How to do using Database tools:

-----------------------------------------------------------------------------------------------------------------------------------------------------------

 

 

  1. Backup database MDB  - Create a Full Database Backup (SQL Server)
  2. Restore database MDB  - How to restore a database backup (Enterprise Manager)
  3. Run script Orphaned Users - Troubleshoot Orphaned Users (SQL Server)
  4. Run pdm_configure

 

OBS: If you change the hostname from server, you need to looking for:

After copying an MDB database from one Service Desk environment to another, pdm_configure fails because the server name … 

 

SQL Name (AKA)TableObject
dlgtsrvDelegation_Serverdlgsrvr

-----------------------------------------------------------------------------------------------------------------------------------------------------------

How to do using CA SDM:

-----------------------------------------------------------------------------------------------------------------------------------------------------------

 

  1. Database Backup
  2. Database Restore  /  CA SDM PDM_Restor - Database Commands - CA Service Management - 14.1

 

 

References:

Database Backup - CA Service Management - 14.1 - CA Wiki

Database Restore - CA Service Management - 14.1 - CA Wiki

 

Backup do banco de dados - CA Service Management - 14.1 - Portuguese - Brazil - CA Wiki

Restauração do banco de dados - CA Service Management - 14.1 - Portuguese - Brazil - CA Wiki

 

 

 

 

CA SDM::. pdm_restore - Invalid backup name 

2 people found this helpful

Attachments

    Outcomes