About Backing up Databases

You should set up a regular backup schedule for your Sage 300 databases, and you should back up after making major changes to your data and before performing major operations such as a year end.

When backing up your database, remember to back up all of the following components:

• System database.
• Company database.
• Shared data.

Backing up a SQL Server Database

Under SQL Server, you must set up regular schedules for backing up the system and company databases and for backing up their database logs.

Database logs record all changes made to a database between backups. You should store your database logs in a different device, and on a different physical drive, from the database (so if one drive fails, you won’t lose your data).

Typically, you back up database logs on a daily basis, and back up the full database weekly. For more information on backing up, see your SQL Server documentation.