Scheduling Automatic Backups

Previous Topic: Restoring a Database

You can schedule automated backups of your ServiceCEO database using command-line options. Before you begin, please read the Backing up the Database topic.

Note!

Note:
The instructions below were written for Windows XP. They may vary slightly depending on the Operating System you are running. For additional assistance using the Windows Task Scheduler, see your Windows documentation.

To schedule an automated backup:

On the server computer, select Start > Programs > Accessories > System Tools > Scheduled Tasks. The Scheduled Tasks dialog box appears.

Double-click Add Scheduled Task. The Scheduled Task Wizard appears.
Click Next. The second page of the Scheduled Task Wizard appears.

Scroll down and select ServiceCEO Backup and Restore.
Click Next. The third page of the Scheduled Task Wizard appears.

Select the option button corresponding to the frequency in which you want to back up your ServiceCEO database.
Click Next. The fourth page of the Scheduled Task Wizard appears.

Define the time, frequency, and any other options for the automatic backup.
Click Next. The fifth page of the Scheduled Task Wizard appears.

Type the Windows user name and password of the Windows user that you want to run the backup. It is a good idea to use a Windows user with administrative privileges here
Click Next. The sixth page of the Scheduled Task Wizard appears.

Select the Open advanced properties for this task when I click Finish check box.
Click Finish. The Task tab of the Backup and Restore Database dialog box appears.

In the Run field, type the following text, including the quotation marks: "C:\Program Files\Insight Direct\Database Management Tools\BackupAndRestore.exe" -backuppath "backuppath" -servername "servername" -databasename "databasename"

replacing the following values with your actual data. All replaced values should be in quotes.
- Replace "backuppath" with the location where you want the backup file to be saved. For example, this value could be: “C:\Backup\ServiceCEO Backups\”.
- Replace "servername" with the name of the server computer. For example: “MyServer”.
- Replace "databasename" with the name of the ServiceCEO database. For example: “ServiceCEO”.
The resulting command line will look similar to the following:
"C:\Program Files\Insight Direct\Database Management Tools\BackupAndRestore.exe" -backuppath "C:\Backup\ServiceCEO Backups" -servername "MyServer" -databasename "ServiceCEO"

Tip!

Tip:
If this command doesn't work for you, try making these adjustments:

You may need to add a backslash "/" after the end of the backup path.
If your SQL Server is installed as a named instance, then you'll need to add the database instance to the server name.

Click OK to save the parameters. The Scheduled Tasks dialog box appears, displaying the automatic backup you just created.

Note these conditions of the automatic backup:

The user must have write access to "backuppath".
If "backuppath" does not exist, it will be created the first time the backup is run.
The backup file will be named using the following scheme: ServiceCEO_Backup_[CurrentDate] [CurrentTime].scb
If a "backuppath" is not supplied, the program will exit without making a backup.
If a backup file with the same name exists, the program will exit without making a backup.
If you are not using the default SQL Server installation from Insight Direct, or you have changed your SA password, then you will need to add an additional switch to the command in step 14:
Type -sapassword “MySApwd” and replace “MySApwd” with your SA password.

Next Topic: The Database Library