Topic results Backup And Restore

CCH Interactive Checklist
How to Backup and Restore a SQL Database
This document provides a guide on how to backup and restore databases using SQL Server Management Studio (SSMS). It explains that SSMS can maintain backups of entire databases and offers a link to download the software if not already installed. Notably, it states that users can only restore entire databases from backups, not individual entries. Additionally, it suggests using the CCH Interactive Checklist software for backing up individual checklists and includes quick and in-depth guide sections with annotated screenshots for a detailed understanding of the process.
More information
CCH Interactive Checklist
Restoring a database - In depth guide
This document provides detailed instructions on restoring a database using SQL Server Management Studio. It covers logging into the SQL Server, selecting the appropriate database, and the steps to access the Restore Database feature. Users are guided on how to specify the backup file, including processing files without the .bak extension. Important warnings regarding data overwriting and confirmation of restore options are highlighted. The document concludes with steps to initiate the restore process and verify its success.
More information
CCH Interactive Checklist
Restoring a database - Quick guide
This document provides instructions for launching SQL Server Management Studio and includes warnings regarding the potential data loss associated with restoring an existing database. Users are cautioned that restoring will overwrite all current contents of the database, rendering the original data irretrievable. Visual aids are included to guide users through the process.
More information
CCH Interactive Checklist
Backing up a database - In depth guide
This document provides a detailed guide on how to perform a database backup using SQL Server Management Studio (SSMS). It outlines the steps to log into the server, select a database, and initiate the backup process. Key points include choosing the appropriate authentication method, configuring backup options (including types and destinations), and ensuring the backup is properly named and located. Additionally, it emphasizes selecting "Overwrite all existing backup sets" and verifying the backup upon completion. The document concludes with a reminder to regularly conduct test restores to ensure backup integrity.
More information
CCH Interactive Checklist
Backing up a database - Quick guide
The document provides a step-by-step guide to launching SQL Server Management Studio (SSMS) from the Start menu. It includes several images to visually assist users during the process. The focus is on ensuring users can easily navigate to the application to manage SQL databases effectively.
More information
CCH Central
CCH Backup and Restore Utility (Installation Guide)
The document provides an installation guide for the CCH Backup and Restore Utility v6.0.1, aimed at IT Support Professionals assisting CCH Clients. It outlines prerequisites such as administrative rights and necessary Microsoft and SQL Server updates. The installation steps include downloading the software, ensuring compliance with prerequisites, and entering user credentials. The guide emphasizes the importance of local administrator access for installation, and it concludes with a legal disclaimer regarding the accuracy and proprietary nature of the provided information.
More information
Training and Consultancy
CCH Backup Checkup Consultancy Online (Basic)
This document outlines a technical service session aimed at reviewing and verifying the backup solution for the CCH Suite, which utilizes Microsoft SQL for data storage. Key objectives include evaluating the current backup model, ensuring SQL backups are functioning, assessing backup frequency and methodology, testing backup schedules, and discussing backup retention and monitoring. The session is conducted remotely without impacting system availability, and participants are advised to complete a technical questionnaire in advance to facilitate effective planning and discussion.
More information
Training and Consultancy
CCH Backup Checkup Consultancy Online (Advanced)
This document outlines a technical service session for optimizing the backup solution of the CCH Suite, which uses Microsoft SQL to store data. It emphasizes the importance of ensuring data backups for business continuity and details the session content, including reviewing the current backup model, verifying SQL backups, testing schedules, and conducting restore tests. The session is remote and does not affect user availability. Participants are encouraged to complete a technical questionnaire to facilitate effective planning and discussion.
More information
Training and Consultancy
CCH Database Restore Service Online
The document outlines the data restoration process for CCH Suite, which relies on Microsoft SQL. It emphasizes the importance of following strict protocols for database restoration to maintain system stability. The process requires SQL expertise and includes a consultancy session for those lacking in-house skills. Session content entails reviewing the current system state, verifying restore settings, restoring databases, and validating system operation. The remote session may affect system availability for users.
More information
Training and Consultancy
CCH Database Backup Service Online
The document outlines the data backup requirements for the CCH Suite, which relies on Microsoft SQL for data storage. Before commencing any work with CCH consultants, a structured backup process is mandatory to ensure system stability, requiring SQL knowledge and server expertise. The consultancy offers a remote session for performing backups and validating system settings, which includes reviewing current system status, confirming SQL backup configurations, executing relevant backups, and restoring operational status. This session may temporarily affect system availability for users.
More information
CCH Central
Troubleshooting Backup and Restore
The document provides troubleshooting guidance for the CCH Backup and Restore Utility, specifically addressing issues with the service's operation. It includes steps to clear the Events log using the Event Viewer, recommending users to contact CCH Customer Care first. Additionally, it outlines how to create a desktop shortcut for the utility by navigating to the specific file location and using the right-click option.
More information
CCH Central
Restore Database
This document provides a step-by-step guide on restoring a database using the CCH Backup and Restore Utility. Key points include selecting the backup file, verifying and entering database and file details, and executing the restoration process. Additionally, it explains how to create a Central user, which is necessary after restoring a database from a different SQL instance. This process ensures that users can log into the restored database effectively. Visual aids, including screenshots, accompany the instructions to enhance clarity.
More information
CCH Central
Logging On
This document offers instructions for logging into the Backup and Restore Utility using SQL Server/Express. Users are guided to launch the application via the MSDEUtil icon, select the appropriate SQL instance, and confirm access. Once logged in, the utility enables users to restore databases, schedule backups, perform on-demand backups, create Central users, and manage service setups. It is noted that administrator rights are required for proper functionality of the utility.
More information
CCH Central
CCH Backup and Restore Utility (User Guide)
The CCH Backup and Restore Utility v6.0.1 user guide outlines installation prerequisites, functionality, and step-by-step instructions for effective database backup and restoration. Key features include restoring databases, scheduling automated backups, and performing on-demand backups. The guide emphasizes the necessity of administrator rights during installation and the option to manage service setups for creating a Central user. Additionally, troubleshooting tips for service management and integration with CCH Central to track backup status are provided. This version supports SQL 2008 Express, addressing compatibility issues present in earlier versions.
More information
CCH Central
CCH Backup and Restore Utility
The CCH Backup and Restore Utility v6.01 facilitates scheduled database backups and restorations for SQL 2005 and SQL 2008 Express. Users can monitor backup task status via CCH Central. This version resolves compatibility issues with SQL 2008 Express. Notably, it supports ad hoc execution of backup jobs and SQL database restoration. Installation requires two files included in the provided zip file, and prior reading of user and installation guides is recommended. The utility does not support MS Small Business Server.
More information
CCH Central
Backup and Restore Home Page Control
The document provides instructions for setting up the CCH Backup and Restore Homepage control within CCH Central for sites that did not install the Backup and Restore Utility using the CSI. It explains how to create a new homepage view, add the Backup Schedule control, and visualize backup status information. Users can track the scheduled backup history and access additional support if needed. The document emphasizes customization options and troubleshooting steps if specific features are unavailable.
More information
CCH Central
Backup Types
The document discusses various backup maintenance routines for databases, emphasizing the importance of tailored approaches based on database size. For small to medium databases, it recommends using complete backups at regular intervals. For large databases, a combination of complete and differential backups is suggested, with complete backups weekly and differential backups every few days, utilizing Log Sequence Numbers to track changes. It also advises using the "Backup a Database Now" and "Copy" options when sending databases to CCH to avoid disrupting log sequence numbering.
More information
CCH Audit Automation
Backup and restore of client data
This document outlines the procedures for backing up and restoring client data in CCH Audit Automation. To back up, users must access the File menu, select "Copy pack," choose the desired client audit pack, and specify the backup location. Additionally, users can opt to back up related master packs. For restoration, the user must locate the backup file and select it. The document also addresses potential issues with missing documents during restoration, advising users to either delete or re-attach those documents in the audit file.
More information
CCH Central
About CCH Backup and Restore
The document provides guidance on the installation and upgrade processes for the CCH Backup and Restore Utility. New installations using the CSI tool will automatically create a maintenance plan for backups of the Central and Document Database. Users looking for additional backup scheduling should consult help resources. For upgrades from version 6.0.1, the utility retains its core functionality but gains the capability for creating Differential and Copy backups. No automatic maintenance plans are generated during upgrades. Typical installation paths for both new and upgraded versions are specified.
More information