Creating a Database Backup

From NewHaven Software Wiki

(Difference between revisions)
Jump to: navigation, search
Line 14: Line 14:
#Check mark 'Truncate the log'
#Check mark 'Truncate the log'
#Under 'Folder in which to create backup image' select Browse
#Under 'Folder in which to create backup image' select Browse
-
#Highlight the folder you wish to create the backup in (Please note: CMS can NOT Create a backup to a networked drive, only local drives)  
+
#Highlight the folder you wish to create the backup in (Please note: The Sybase service, which by default runs as LocalSystem, cannot access network drives, only local.)  
#Select Ok
#Select Ok
#Select Save these settings now.  
#Select Save these settings now.  

Revision as of 00:58, 8 March 2012

Overview

This article covers how to create a Database backup in CMS 8.0

Setting up CMS to create a daily backup

To have CMS automatically create a backup of your database to a specified folder, please follow the instructions below.

  1. Log into your PCI Administration account
  2. Select the PCI Administration drop down menu
  3. Select Administration
  4. Select Daily Backup
  5. Select 'Perform the daily backup at the time and in the folder specified below'
  6. Under Time to Backup, set the time you wish the backup to be created at.
  7. Check mark 'Truncate the log'
  8. Under 'Folder in which to create backup image' select Browse
  9. Highlight the folder you wish to create the backup in (Please note: The Sybase service, which by default runs as LocalSystem, cannot access network drives, only local.)
  10. Select Ok
  11. Select Save these settings now.

CMS will now create a backup to that specified folder, every day, at the time you have specified.

How to have CMS create an immediate backup of your database

  1. Log into your PCI Administration account
  2. Select the PCI Administration drop down menu
  3. Select Administration
  4. Select Daily Backup
  5. Under 'Folder in which to create backup image' select Browse
  6. Highlight the folder you wish to create the backup in (Please note: CMS can NOT Create a backup to a networked drive, only local drives)
  7. Select Ok
  8. Select 'Immediately create a Backup Image in the specified folder'

CMS will create a backup to the folder you have specified.

Personal tools