How To Backup MS SQL Database
Protecting MS SQL Database(s) is a major task. FGS Backup ensures to give you an easy to use, Continuous Data Protection backup for databases and the entire MS SQL Server instances.
In order to back up your MS SQL Database, please refer to the following steps:
- Before you start backing up your MS SQL databases, you need to activate the MS SQL on the machine by applying the steps in this article: MS SQL Machine Activation
2. Open the FGS Backup desktop software installed on the machine where the MS SQL is installed → Click the MS SQL option on the Dashboard.
If the FGS Backup desktop software is not installed yet, please download its setup file from here and install it.
Important! Only the administrator users of the FGS Backup accounts will see the MS SQL option on the Dashboard of their FGS Backup desktop software.
3. A message will show up asking you to activate MS SQL backup on your device. Click the Activate button.
4. From the MS SQL Manager window, click the Add Job button.
5. From the new Authenticator pop-up window, expand the Server Name drop-down list and select the <Enter Server Name> option if the server you want to backup the MS SQL database(s) from is not already in the list.
6. In the new Server Custom Name pop-up window, type the name of the server which holds the MS SQL database(s) you want to backup. The server name should be in the following format: ServerHostName/InstanceName → Click OK to go back to the Authenticator pop-up window and type the credentials (Username & password) of the server you just added → Click the Connect button.
7. FGS Backup will connect to the server you just added, and it will show you a list of the available MS SQL databases that are available under this added server. Select the database(s) you want to backup → Click the Next button.
8. In the MS SQL Backup Job Settings window, set the backup settings and click the Save button.