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

Restoring a Webgility Desktop Database Backup After SQL Installation or System Failure

This article helps Webgility Desktop users restore a database backup, particularly after reinstalling SQL Server 2022, migrating to a new system, or recovering from a hard drive failure. It provides step-by-step instructions to preserve data, configurations, and sales channel connections. Users are also reminded to install both SQL Server and Webgility Desktop on the machine before beginning the restore process.

Installation Options for SQL Server

Option A: Install SQL Server via Webgility Desktop

  1. Launch Webgility Desktop.

  2. On the setup screen, select:
    “This is a new computer, install SQL Server and create Webgility database.”

  3. Click Continue and follow the on-screen instructions.

Option B: Manual SQL Server 2022 Installation

  1. Download and install SQL Server 2022 using the official installer.

  2. Follow all prompts, and do not select the PolyBase feature to avoid excessive dump log generation.

  3. Complete installation and apply any required updates or service packs.

Restoring the Webgility Database

Step 1: Prepare the Backup File

Copy your most recent .bak file (typically named UnifyDB.bak) to the following location:
C:\Webgility on the new or target machine.

Step 2: Restore the Backup in Webgility Desktop

  1. Open Webgility Desktop.

  2. Navigate to:
    System > Database > Restore

  3. When prompted about overwriting data, click Yes.

  4. Browse to select your .bak file and click Open.

  5. Wait for the confirmation message and click OK.

  6. The application will close automatically—reopen Webgility Desktop to confirm the restoration is successful.

Identifying the SQL Workstation (If Migrating or Reconnecting)

To verify which machine is hosting SQL Server:

  1. Navigate to:
    C:\Webgility\UnifyEnterprise\XML

  2. Open the file named apiconfig in Notepad.

  3. Locate the SQL Server name to confirm the correct server for restoration or connection.

If You Are Using RightNetworks (RightWorks)

Customers hosted on RightNetworks (Now RightWorks) must contact their support directly to request a Webgility database backup or restoration. All database operations are managed on their end.

Post-Restoration Checklist

  • Confirm Webgility Desktop launches without errors.

  • Verify that your sales channel connections, settings, and data are accurate.

  • Test posting a few sample transactions.

  • Ensure the restored data reflects your most recent backup state.

Best Practices

  • Schedule regular automated backups.

  • Store backup files securely in a location separate from the live system.

  • Avoid selecting unnecessary features like PolyBase during SQL Server installation to prevent storage issues.