Creating a Database Backup - Revision history

Dan hacker: /* Special Note About Mapped Drives/UNC */

2023-06-21T18:32:05Z

Special Note About Mapped Drives/UNC

← Older revision		Revision as of 18:32, 21 June 2023
Line 49:		Line 49:

	==Special Note About Mapped Drives/UNC==		==Special Note About Mapped Drives/UNC==
	Sometimes there is a situation where the database ~~Service~~ cannot access mapped drives. In ~~these cases~~ it is necessary to use UNC ~~paths~~ instead. In order for CMS to interpret the ~~paths~~ successfully, the double-backslash needs to be escaped using an additional double-backslash. So if your UNC path is \\myshare\backup, you need to enter it as \\\\myshare\backup.		Sometimes there is a situation where the database backup service cannot access mapped drives. In this case it is necessary to use a UNC path instead. In order for CMS to interpret the path successfully, the double-backslash needs to be escaped using an additional double-backslash. So if your UNC path is \\myshare\backup, you need to enter it as \\\\myshare\backup.

Dan hacker at 18:31, 21 June 2023

2023-06-21T18:31:14Z

← Older revision		Revision as of 18:31, 21 June 2023
Line 48:		Line 48:
	CMS will create a backup to the folder you have specified.		CMS will create a backup to the folder you have specified.

	====Special Note About Mapped Drives/UNC====		==Special Note About Mapped Drives/UNC==
	Sometimes there is a situation where the database Service cannot access mapped drives. In these cases it is necessary to use UNC paths instead. In order for CMS to interpret the paths successfully, the double-backslash needs to be escaped using an additional double-backslash. So if your UNC path is \\myshare\backup, you need to enter it as \\\\myshare\backup.		Sometimes there is a situation where the database Service cannot access mapped drives. In these cases it is necessary to use UNC paths instead. In order for CMS to interpret the paths successfully, the double-backslash needs to be escaped using an additional double-backslash. So if your UNC path is \\myshare\backup, you need to enter it as \\\\myshare\backup.

Dan hacker at 18:30, 21 June 2023

2023-06-21T18:30:52Z

← Older revision		Revision as of 18:30, 21 June 2023
Line 47:		Line 47:

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

			====Special Note About Mapped Drives/UNC====
			Sometimes there is a situation where the database Service cannot access mapped drives. In these cases it is necessary to use UNC paths instead. In order for CMS to interpret the paths successfully, the double-backslash needs to be escaped using an additional double-backslash. So if your UNC path is \\myshare\backup, you need to enter it as \\\\myshare\backup.

Russ horton at 16:37, 7 August 2020

2020-08-07T16:37:37Z

← Older revision		Revision as of 16:37, 7 August 2020
Line 31:		Line 31:

	Truncation occurs during the scheduled backup event but does not occur when creating an immediate backup (see below.)		Truncation occurs during the scheduled backup event but does not occur when creating an immediate backup (see below.)

			====Training Database====
			If you are running a Training database, chances are you do not need a backup of this and the daily backup should be disabled. If you decide that you want to backup the Training database as well, please do so to a different directory and backup time than your production database to avoid conflicts (the training database uses the same log file name.)

	==How to have CMS create an immediate backup of your database==		==How to have CMS create an immediate backup of your database==

Russ horton at 16:20, 7 August 2020

2020-08-07T16:20:18Z

← Older revision		Revision as of 16:20, 7 August 2020
Line 7:		Line 7:

	#Log into your PCI Administration account		#Log into your PCI Administration account
	#Select the PCI Administration drop down menu		#Select the PCI Administration drop-down menu
	#Select Administration		#Select Administration
	#Select Daily Backup		#Select Daily Backup
	#Select 'Perform the daily backup at the time and in the folder specified below'		#Select 'Perform the daily backup at the time and in the folder specified below'
	#Under Time to Backup, set the time you wish the backup to be created at.		#Under Time to Backup, set the time you wish the backup to be created.
	#Check mark 'Truncate the log' (see below)		#Check mark 'Truncate the log' (see below)
	#Under 'Folder in which to create backup image' select Browse		#Under 'Folder in which to create backup image' select Browse
Line 23:		Line 23:
	Your database is a single file and contains all of your data. This file is locked by the Sybase database server, however, and cannot be copied, moved, deleted, or backed up. Using the above backup schedule allows Sybase to create a copy of its live database without having to shut down the database server. This also allows for 24/7 operation without having to stop to facilitate a backup.		Your database is a single file and contains all of your data. This file is locked by the Sybase database server, however, and cannot be copied, moved, deleted, or backed up. Using the above backup schedule allows Sybase to create a copy of its live database without having to shut down the database server. This also allows for 24/7 operation without having to stop to facilitate a backup.

	The backup of your database is almost all you need in order to recover from catastrophe like a failed drive, stolen server, or office fire (we've seen all of these.) Make sure you're backing up nightly and taking/uploading copies offsite regularly. The rest of your CMS install can be reinstalled in minutes, drop your backup in, and your back in business. No need to backup/protect the rest of the files in the NewHaven Software server share.		The backup of your database is almost all you need in order to recover from a catastrophe like a failed drive, stolen server, or office fire (we've seen all of these.) Make sure you're backing up nightly and taking/uploading copies offsite regularly. The rest of your CMS install can be reinstalled in minutes, drop your backup in, and your back in business. No need to backup or protect the rest of the files in the NewHaven Software server share. If, however, you are storing your own files under our directory, please consider if they should be backed up.

	As of CMS TEN, there is one exception to the above. You'll also ~~need to have~~ a copy of your CMSdbo.ini file. This file does not change daily but it can change every 90 days or when a CMS update is installed. This file contains an encrypted portion of a partial password that CMS uses to access the database. Without this file CMS cannot run and it is unique to you and your database. Be sure to also have a copy of this in your offsite backups and as part of any backup restoration procedure. If you do not have this file and need to restore a backup, the database file will have to be sent to NewHaven Software where the password can be reset. This process is time consuming and is not part of standard support.		As of CMS TEN, there is one exception to the above. You'll also want a backup copy of your CMSdbo.ini file. This file does not change daily but it can change every 90 days or when a CMS update is installed. This file contains an encrypted portion of a partial password that CMS uses to access the database. Without this file, CMS cannot run and it is unique to you and your database. Be sure to also have a copy of this in your offsite backups and as part of any backup restoration procedure. If you do not have this file and need to restore a backup, the database file will have to be sent to NewHaven Software where the password can be reset. This process is time-consuming and is not part of standard support.

	====Truncating the Log====		====Truncating the Log====
	For normal operation we recommend that you run with the Truncate option enabled. Truncation keeps the size of your log file down to only include database changes since your last backup. This will save space on your server and potentially improving performance. Typically you'd only run with truncation disabled if you're working with NewHaven Software Support to troubleshoot a problem that cannot be replicated and need to build up a log file over time.		For normal operation, we recommend that you run with the Truncate option enabled. Truncation keeps the size of your log file down to only include database changes since your last backup. This will save space on your server and potentially improving performance. Typically you'd only run with truncation disabled if you're working with NewHaven Software Support to troubleshoot a problem that cannot be replicated and need to build up a log file over time.

	Truncation occurs during the ~~schedule~~ backup event but does not occur when creating an immediate backup (see below.)		Truncation occurs during the scheduled backup event but does not occur when creating an immediate backup (see below.)

	==How to have CMS create an immediate backup of your database==		==How to have CMS create an immediate backup of your database==

	#Log into your PCI Administration account		#Log into your PCI Administration account
	#Select the PCI Administration drop down menu		#Select the PCI Administration drop-down menu
	#Select Administration		#Select Administration
	#Select Daily Backup		#Select Daily Backup

Russ horton at 23:40, 3 March 2016

2016-03-03T23:40:56Z

← Older revision		Revision as of 23:40, 3 March 2016
Line 12:		Line 12:
	#Select 'Perform the daily backup at the time and in the folder specified below'		#Select 'Perform the daily backup at the time and in the folder specified below'
	#Under Time to Backup, set the time you wish the backup to be created at.		#Under Time to Backup, set the time you wish the backup to be created at.
	#Check mark 'Truncate the log'		#Check mark 'Truncate the log' (see below)
	#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: The Sybase service, which by default runs as LocalSystem, cannot access network drives, only local.)		#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.)
Line 26:		Line 26:

	As of CMS TEN, there is one exception to the above. You'll also need to have a copy of your CMSdbo.ini file. This file does not change daily but it can change every 90 days or when a CMS update is installed. This file contains an encrypted portion of a partial password that CMS uses to access the database. Without this file CMS cannot run and it is unique to you and your database. Be sure to also have a copy of this in your offsite backups and as part of any backup restoration procedure. If you do not have this file and need to restore a backup, the database file will have to be sent to NewHaven Software where the password can be reset. This process is time consuming and is not part of standard support.		As of CMS TEN, there is one exception to the above. You'll also need to have a copy of your CMSdbo.ini file. This file does not change daily but it can change every 90 days or when a CMS update is installed. This file contains an encrypted portion of a partial password that CMS uses to access the database. Without this file CMS cannot run and it is unique to you and your database. Be sure to also have a copy of this in your offsite backups and as part of any backup restoration procedure. If you do not have this file and need to restore a backup, the database file will have to be sent to NewHaven Software where the password can be reset. This process is time consuming and is not part of standard support.

			====Truncating the Log====
			For normal operation we recommend that you run with the Truncate option enabled. Truncation keeps the size of your log file down to only include database changes since your last backup. This will save space on your server and potentially improving performance. Typically you'd only run with truncation disabled if you're working with NewHaven Software Support to troubleshoot a problem that cannot be replicated and need to build up a log file over time.

			Truncation occurs during the schedule backup event but does not occur when creating an immediate backup (see below.)

	==How to have CMS create an immediate backup of your database==		==How to have CMS create an immediate backup of your database==

Russ horton: /* Setting up CMS to create a daily backup */

2016-03-03T02:22:05Z

Setting up CMS to create a daily backup

← Older revision		Revision as of 02:22, 3 March 2016
Line 18:		Line 18:
	#Select Save these settings now.		#Select Save these settings now.

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

			===Important Info on Backup Routines===
			Your database is a single file and contains all of your data. This file is locked by the Sybase database server, however, and cannot be copied, moved, deleted, or backed up. Using the above backup schedule allows Sybase to create a copy of its live database without having to shut down the database server. This also allows for 24/7 operation without having to stop to facilitate a backup.

			The backup of your database is almost all you need in order to recover from catastrophe like a failed drive, stolen server, or office fire (we've seen all of these.) Make sure you're backing up nightly and taking/uploading copies offsite regularly. The rest of your CMS install can be reinstalled in minutes, drop your backup in, and your back in business. No need to backup/protect the rest of the files in the NewHaven Software server share.

			As of CMS TEN, there is one exception to the above. You'll also need to have a copy of your CMSdbo.ini file. This file does not change daily but it can change every 90 days or when a CMS update is installed. This file contains an encrypted portion of a partial password that CMS uses to access the database. Without this file CMS cannot run and it is unique to you and your database. Be sure to also have a copy of this in your offsite backups and as part of any backup restoration procedure. If you do not have this file and need to restore a backup, the database file will have to be sent to NewHaven Software where the password can be reset. This process is time consuming and is not part of standard support.

	==How to have CMS create an immediate backup of your database==		==How to have CMS create an immediate backup of your database==

Rob parkes at 23:32, 6 June 2014

2014-06-06T23:32:50Z

← Older revision		Revision as of 23:32, 6 June 2014
Line 1:		Line 1:
	=Overview=		=Overview=
	This article covers how to create a Database backup in CMS 8.0		This article covers how to create a Database backup in CMS 8.0 or later.

	==Setting up CMS to create a daily backup==		==Setting up CMS to create a daily backup==

Russ horton at 00:58, 8 March 2012

2012-03-08T00:58:06Z

← Older revision		Revision as of 00:58, 8 March 2012
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.

Luke steinmetzer at 18:09, 21 February 2012

2012-02-21T18:09:36Z

← Older revision		Revision as of 18:09, 21 February 2012
Line 1:		Line 1:
	==Overview==		=Overview=
	This article covers how to create a Database backup in CMS 8.0		This article covers how to create a Database backup in CMS 8.0

	=Setting up CMS to create a daily backup=		==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.		To have CMS automatically create a backup of your database to a specified folder, please follow the instructions below.
Line 20:		Line 20:
	CMS will now create a backup to that specified folder, every day, at the time you have specified.		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=		==How to have CMS create an immediate backup of your database==

	#Log into your PCI Administration account		#Log into your PCI Administration account