HOW TO
How To Backup MS SQL Database
Important! DaytaPol supports MS SQL Server versions 2008 R2, 2012, 2014 and 2016.
Protecting MS SQL Database(s) is a major task. DaytaPol 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:
1. 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 DaytaPol desktop software installed on the machine where the MS SQL is installed → Click the MS SQL option on the Dashboard.
If DaytaPol desktop software is not installed yet, please install it before we continue.
Important! Only the administrator users of the DaytaPol accounts will see the MS SQL option on the Dashboard of their DaytaPol 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. DaytaPol 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.
Related Articles
How to generate logs for users who have policies assigned
How to generate logs for users who have policies assigned If you have a policy assigned to you, and need to generate the logs for...
How to Generate the Advanced Debug Logs
How to Generate the Advanced Debug Logs For troubleshooting purposes, the Technical Support may ask for trace logs of the program....
Ransomware Protection: How To Restore Files If Malware Encrypts Them
Ransomware Protection: How To Restore Files If Malware Encrypts ThemData on the Cloud does not get affected by any malware that could...
The Audit option
The Audit option DaytaPol keeps records for each action taken on the system or on the machine where DaytaPol software is installed,...
General questions about files sharing
General questions about files sharing Q. Can I share files and folders with anyone whether they have DaytaPol or not? A. The person...