Protecting MS SQL Database(s) is a major task. Zoolz Intelligent 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
- Open Zoolz Intelligent desktop client on your machine→ Click the MS SQL option on the Dashboard.
Important! Only the administrator users of the Zoolz Intelligent accounts will see the MS SQL option on the Dashboard of their Zoolz Intelligent desktop software.
- A message will show up asking you to activate MS SQL backup on your device. Click the Activate button.
- From the MS SQL Manager window, click the Add Job button.
- 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.
- 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.
- Zoolz Intelligent 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.
- In the MS SQL Backup Job Settings window, set the backup settings and click the Save button.
Currently, Zoolz Intelligent will backup only the named SQL instance. When it comes to the not named (Default) SQL instances, it will not be backed up. Here are some examples of named and default SQL instances: