Skip to content
  • There are no suggestions because the search field is empty.

How to Fix the “Incorrect Database” Error During Webgility Desktop Migration

This article helps Webgility Desktop users troubleshoot the 'Incorrect database' error encountered when migrating Webgility Desktop and its database from a RightWorks environment to a Summit Hosting environment. It covers common causes such as backup file location, permissions, and database compatibility issues, and provides recommended steps to resolve these problems for a smooth migration.

Overview

When migrating Webgility Desktop (WD) from an RN to a Summit environment, users may encounter the 'Incorrect database' error during the database restore process. This typically occurs due to issues with the backup file location, permissions, or database compatibility. This article outlines recommended troubleshooting steps to help resolve the error and ensure a smooth migration.

Troubleshooting Steps

1. Recommended Backup Location

To avoid the 'Incorrect database' error, it’s essential to create the Webgility database backup from a valid and accessible location.

  • Recommended Location:
    The C: Drive of the same machine where SQL Server is installed and running the Webgility Database.

  • Steps:

    1. Create a new folder, e.g., C:\Webgility\Backup.

    2. In Webgility, go to:
      System > Database > Backup.

    3. Select the folder created in Step 1 and click OK to initiate the backup.

Note: If you are initiating the backup from an Add-on computer (not the main host), ensure you're connected to the correct SQL instance and that you are using a valid local folder path.

2. Check and Adjust Folder Permissions

Insufficient permissions on the backup folder may result in an unusable or incomplete backup file, leading to the 'Incorrect database' error during restoration.

  • Steps to Adjust Permissions:

    1. Navigate to the Webgility installation folder (e.g., C:\Webgility).

    2. Right-click the folder > select Properties.

    3. Go to the Security tab.

    4. Click Edit > Add.

    5. Type Everyone > click Check Names > OK.

    6. Check the box for Full Control.

    7. Click Apply > OK.

  • Once permissions are set, create a new backup and try restoring it again in the Summit environment.

Still Encountering Issues?

If you've followed the steps above and are still seeing the 'Incorrect database' error:

  • Ensure the backup file is not corrupted or incomplete.

  • Try restoring the backup using SQL Server Management Studio (SSMS) to validate it.