How to restore a database using the CCH Backup and Restore Utility.

Restore Database File

  1. To restore a database using an existing backup file, on the main menu, click File > Restore Database.

RestoreDB.png

RestoreDBWindow.png

  1. In the Restore Database window, select the backup file by clicking the Ellipsis button Buttom Ellipisis.PNG in the Backup file field. 
    Within the Select backfile to restore window browse to the backup file you want to restore. 

SelectBackupFiletoRestore.png

The utility recognises the database that the backup file is associated with and automatically populates the rest of the fields.

PopulatedRestoreDBWindow.png

  • Restore As – This is the database name that will be restored using the file specified in the Backup file field.  If this is not the database that you would like to restore, delete the database name and type the name of the database required. 
  • Data File – This is the location of the data file associated with the database.  If the path is not correct, click in the field and change the information to point to the correct data file path. 
  • Log File – This is the location of the log file associated with the database.  If the path is not correct, click in the field and change the information to point to the correct log file path. 
  1. When you are happy that all the information provided is correct, click OK to restore the database. 
    You will see a status bar at the bottom of the window indicating the progress of the database restoration. 

SuccessfulRestore.png

  1. When the restoration is complete, click OK to close the window. 

How to create a Central user. 

This is necessary for CCH Central to login to a chosen database. 

Note: Creating the Central User is only required to be run if a database has been restored from another SQL instance backup.

  1. From the CCH Backup and Restore Utility menu, select Tools > Create Central User. 

CreateCentralUser1.png

  1. In the Create Central User window:

CreateCentralUser2.png

  • Server - This field indicates the server instance that you are logged in to.
  • Database - Select the database from the drop-down list that the Central user will be created for and click OK to create the Central user.

CreateCentralUser3.png

  1. In the confirmation prompt, click Yes to create the Central user.

Related documents

CCH Central Suite Update Guide (Latest Offline Version)
The document outlines the process for using the Central Suite Installer Offline (CSI Offline) for customers with specific IT requirements that prevent internet updates. It provides detailed instructions for installing updates to the Central Suite, including necessary prerequisites, folder structure, and the installation steps. Key points include ensuring Microsoft SQL Server is supported, confirming .NET Framework requirements, and the importance of backups before starting the update. The document also highlights the need for administrator rights, handling database upgrades, and checking for office plugin updates, particularly for users of CCH Document Management.
CCH Central Suite 2026.3 Update Guide
This guide explains how to update an existing install of the CCH Central Suite to the latest version 2026.3 (including Service Packs and Hotfixes) using the Central Suite Installer (CSI).
CCH Central 2026.3 Release Notes
CCH Central 2026.3 Release Notes
Central Suite Installer (CSI) instructions
The document announces the update of the Central Suite Installer (CSI) for the CCH Central Suite, now compatible with the latest releases and service packs and hotfixes of various CCH applications. Key points include prerequisites for installation, compatibility information, and the necessity for proper backup before proceeding with the update. It highlights specific requirements for Microsoft components, and it warns users of CCH Accounts Production regarding regional settings for date format. Support options are mentioned for users seeking assistance during the update process. Release notes are accessible for detailed information on the updates.
CCH Central 2026.210 Service Pack
CCH Central 2026.210 Service Pack