How to Back Up MS SQL Server
Backup Agent for Windows enables you to perform backup of Microsoft SQL Server. The backup software uses native SQL Server backup procedures to perform database backup and then moves it directly to the cloud. User doesn't need MS SQL Server administration skills to perform a successful backup every time it's required.
It is recommended to create only one backup plan for every MS SQL Server database to avoid one plan interfering with another. In case you need to back up the SQL Server data to several locations try to select a hybrid backup on Select Backup Storage step of the backup wizard.
Learn more how to request Backup Agent in the following topic.
Configuring Backup Plan for MS SQL Server
To start working with MBS Agent for MS SQL Server, install and launch it, then click on "MS SQL Server" button in the top bar.
In the backup wizard you will need to select SQL Server instance and the authentication method. You can choose either SQL Server or Windows authentication. After selection of preferable authentication method you will be asked to enter your username and a password.
On the next step user can choose proper databases to backup. Option list allows you to choose whether you need to backup all your databases, only user databases or to select particular database manually.
Next step is a compression and encryption options setup. If you use MS SQL Server 2008 or higher, compression will be performed by SQL Server. If not, compression will be performed by the backup software.
Then you will have to specify schedule options. You can run a backup plan manually or can setup the application to backup your files automatically. Program can be set on automatic backup at a certain time on a schedule or at user-specified intervals. User can choose whether to use predefined templates or configure advanced schedule.
On the next step you will need to specify the start date and select schedule template.
If you have chosen an advanced schedule mode, you will be asked to set options for full backup, differential backup and transaction log backup. Here you can set date, time and frequency for each backup type. Also on this step yo will have to define the start date to run your first backup.
Specify pre-/post actions.
Starting from Management Console version 5.0, pre- or post- actions for Backup Agents can be restricted by provider. To learn more about the pre-/post action settings, refer to the Global Agent Options and Companies chapters
On the summary page you can overview the backup plan options and run backup plan.