From Sage Install Guide: Always use Database Administration to back up your data. Database Administration backs up numerous files (including external files, such as attachments) that are not part of the SQL database, and it performs additional steps to ensure that you can successfully restore your data from a backup copy. Do not attempt to back up Sage 100 Contractor data using Microsoft SQL Server Management Studio or other third-party software, or you will be unable to restore the company.
By default, when you create a new company through the Database Administration tool, it will automatically set up two weeks of backup retention. You can also change the retention period by going through the "Schedule Nightly Maintenance" tab. These locally kept Sage backups will be the quickest way to recover a clients company file, and will require no intervention from Swizznet. For this reason, we suggest that you keep the default two weeks of retention.
By default, the copies will be kept at this location: D:\Sage100Con\Backup\Nightly. When Swizznet's nightly backup process runs, we will also make another backup of these files and keep the last 30 days of backups.