This document outlines database backups and maintenance options for the Swizznet environment. It is first organized by Sage product then outlines how to setup SQL backups and SQL maintenance plans. While Swizznet will back up your data and database for you, it is critical that you understand how we accomplish this.
In addition, when utilizing an SQL server it is important to understand that there are some maintenance and monitoring requirements that are necessary with SQL. These requirements will help keep your environment running smoothly.
Swizznet cannot maintain your databases. In many cases we do not have permission to access your databases, therefore, you must do this if you want to have a healthy SQL environment. This document will first cover the backup strategies for each Sage product at a high level and will provide in-depth technical information including links you should familiarize yourself with.
Recommended Backup Strategies
- Sage 100 Contractor
- Sage 300 CRE
- Sage Estimating
- Sage 300 ERP
- SQL Server Backup Methodologies
- Sage Paperless