Scheduling Automatic ServiceCEO Database Backups
Solution 00000233 in the Member Center
Hint: Select 'Find Solution' in the Member Center and search on "scheduled backup"

Print this page


Learn more about the Member Center...
Overview
You can schedule automated backups of your ServiceCEO database using command-line options.

Prerequisites
Before you begin, please read the manual backup process as outlined in the "Backing up your Database" section of the Implementation Manual, located at http://www.insightdirect.com/documentation/ServiceCEO.htm

LOCAL_DB_UTIL Version: Users who installed their ServiceCEO server components prior to 02/20/2004 may need to download an updated Local Database Utility (Version 1.0.0.15) file in order to use all command-line backup options. The latest database utility is located at http://www.insightdirect.com/LOCAL_DB_UTIL.zip. This file should be downloaded and extracted into the C:\Program Files\ServiceCEO\MSDE directory.

Operating System Version
The instructions below may vary slightly depending on the Operating System you are running. For additional assistance using the Windows Task Scheduler, see your Windows documentation.

Solution
Please perform the following actions on the computer hosting your ServiceCEO database:

  1. Select START - PROGRAMS - ACCESSORIES - SYSTEM TOOLS - SCHEDULED TASKS. The Scheduled Tasks dialog box appears.
  2. Double-click ADD SCHEDULED TASK. The Scheduled Task Wizard appears.
  3. Click NEXT.
  4. Scroll down and select BACKUP OR RESTORE DATABASE.
  5. Click NEXT.
  6. Select the option button corresponding to the frequency in which you want to back up your ServiceCEO database.
  7. Click NEXT.
  8. Define the time, frequency, and any other options for the automatic backup.
  9. Click NEXT.
  10. Type the user name and password of the user that you want to run the backup. It is a good idea to use a user with administrative privileges here.
  11. Click NEXT.
  12. Select the OPEN ADVANCED PROPERTIES FOR THIS TASK WHEN I CLICK FINISH check box.
  13. Click FINSH. The Task tab of the Backup and Restore Database dialog box appears.
  14. In the RUN field, type the following text, including the quotation marks:
"C:\Program Files\ServiceCEO\MSDE\LOCAL_DB_UTIL.exe" -backuppath "C:\Documents and Settings\Administrator\Desktop" -dobackup
    NOTE: The location of your backup file can be changed to any location you wish. Simply replace the "Documents and Settings\Administrator\Desktop" path with the location on your computer where you would like to create your backup files.
  15. Click OK to save the parameters.

Your automatic backup is scheduled!

Additional information

Command Line Parameters
-------------------------------------------------------------------------
Parameter: dobackup
Example Usage: LOCAL_DB_UTIL.exe -dobackup
Explanation: This parameter enables the program to run without a User Interface (UI) and automatically performs a date-stamped backup in the same location used for the previous backup. If a backup with the same date stamp exists, it will be overwritten. If errors are encountered, appropriate message boxes will pop up in the same manner as if the backup was run manually.

Parameter: backuppath
Example Usage: LOCAL_DB_UTIL.exe -backuppath "C:\MY BACKUPS\" -dobackup
Explanation: This parameter explicitly defines the path to which the date-stamped file will be written, and overrides the default behavior of using the last known backup path.