Database Backup Failed

Problem

You cannot create a backup of the database. The error message that you see on the screen is, 'Database backup failed'.

Cause

You cannot create a backup of the database because of one of the following reasons:

• Your antivirus program is blocking the MYSQL or PGSQL dump operation
• Specified directory is write-protected, invalid or inaccessible
• Insufficient space in the specified drive
• Temp Folder is full

Resolution

You are required to identify why you are not able to create the database. Follow the relevant resolution:

Adding the required folders to the exception list of your antivirus program

Check if the antivirus program is running in the computer where the Desktop Central server is running. If it is, add the folder named DesktopCentral_Server to the exception list of the antivirus program. This folder is typically located in the installation directory of your computer. For example, C:\Program Files.

Adding Folders to the Exception List of Norton Antivirus

Assume that you have Norton Antivirus 2009 installed in your computer. To add a folder to the exception list of the Norton antivirus program, follow the steps given below:

1. Open the Norton Antivirus program
2. Click Settings
3. In the Exclusions/Low Risks section, click Configure
4. Click Add
5. Navigate to C:\Program Files and add the folder DesktopCentral_Server to the list
6. Click Apply
7. Click OK

You've added the required folder to the exception list in your the antivirus program installed in your computer.

Specifying a valid folder name that is not write-protected

Specify a valid folder name for the backup directory path. If you're using a network share, the directory should have write permission for everyone in the network.

Scenario

Assume that you have created a folder called Database Backup in a computer (not the computer where the Desktop Central server is installed) in your network. This folder will be used to store all the database backup that is created every week. To enable all the users in your network to access this folder to store their database backup, you must give them share permissions. To share a folder and give share permissions to everyone in the network, follow the steps given below:

1. Navigate to the required folder
2. Right-click on the folder
3. Click Properties
4. Click Sharing
5. Click Share this folder
6. Enter a name for the folder
7. Click Permissions
8. In the Group or user names section, select Everyone
9. In the Permissions for Everyone section, select Full Control
10. Click Apply
11. Click OK

Note: Repeat steps 10 and 11 to complete the process.

You've shared a specific folder with permission for everyone in the network to access and use it.

Ensuring that there is enough space in the required drive

Check the amount of free space in the drive. If there isn't enough space do one of the following:

• Delete or move unwanted files
• Extend the hard drive capacity
• Change the backup directory to another drive

Changing the backup directory to another drive

To change the backup directory to another drive, follow the steps given below:

1. Click the Admin tab
2. In the Tools section, click Database Backup
3. In the Backup directory field, specify a new drive to save the backup in
4. Click Save Changes

You've changed the backup directory to another drive. Follow the steps given in the follow up section below, to check if you can create a backup.

Clear Temp Folder

Ensure that you clear up the temp folder in the Server machine before trying to take a back up. To clear the folder, follow the steps mentioned below.

1. Click Start Run
2. type %temp% press enter
3. Clear the temp folder's content.

Follow Up

After using the required solution, mentioned in the section above, you can check manually whether the database backup takes place successfully. To create a backup of the database manually, follow the steps given below:

1. Click Start>Run
2. Enter cmd
3. Click OK
4. Navigate to <Install_Directory>/DesktopCentral_Server/bin directory

   Note: This is where the folder DesktopCentral_Server is stored. For example, the path could be D:\>DesktopCentral_Server.

5. Run backuprestore.bat to view the Backup/Restore Graphical User Interface (GUI)
6. Click the Backup tab
7. Select the location that you want to save the backup file in
8. Click Backup

   Note: Desktop Central first estimates how much space is available in the specified drive where you want to store the backup file.

You have created the backup file. The backup file is stored at the location you chose. The naming format is buildnumber-date-time.zip. For example, 70117-Jul-23-2010-11-26.zip

Applies to: Database backup, Creation

Keywords: Database backup-creation failure, Version incompatbility