Backing up a Microsoft SQL database
The console includes a site backup that you can use to back up and later restore the database. In addition, you can set up a maintenance plan on the Microsoft SQL Server Agent.
The following procedure includes recommended settings.
You may need to use different settings depending on the following criteria:
The size of your organization.
The amount of disk space you have reserved for backups.
Any required guidelines at your company.
To back up a Microsoft SQL database on demand
In the console, click Admin, and then click Servers.
Under View Servers, click the icon that represents the Microsoft SQL database.
Under Tasks, click Back Up Site Now.
This method backs up all of the site data, including the database. You can check the System log as well as the Backup folder for status during and after the backup.