How to setup a Microsoft SQL database backup in Nordic Backup Pro

Print the user guide -
The first steps to setup a SQL backup job with Nordic Backup Pro is to verify that the settings of the SQL server are correct. We recommend that the database Recovery Model be set to full and you create an account within SQL Server to be used exclusively for Nordic Backup.

Begin by opening the SQL Server Management Studio, then expand your server as shown on the right. Then expand "Databases", and then right click on the database you would like to backup and click "Properties".
Change the database recovery model to Full
In the "Database Properties" screen, click on "Options" in the left pane.

Then click on the drop down box next to "Recovery Model". This should be set to "Full". The default on a new SQL installation is "Simple" which will cause the backup job to fail. Click "OK".
Change the database recovery model to Full
Nordic Backup also recommends using an exclusive account setup within SQL that can be used to backup the databases. The account needs to be setup with SQL only anuthentication, having the "SysAdmin" role for full access to the databases.

Expand the "Security" section below databases, then right-click on "Logins", then left-click on "New Login" in the pop-up.
Setup a new user to be used for backups
In the "Login-New" screen, first select the radio button to use "SQL Server Authentication". Then enter the account user name you wish to use in the top box. We recommend "Nordic Backup SQL". Enter the account password of your choice.

Then uncheck the box to "Enforce Password Policy". This will ensure the account password will not expire and there are no complexity requirements.
Assign an account username and password


Click on the "Server Roles" in the left pane to change the roles for the account. Check the box for the "SysAdmin" role.

Click "OK" when complete, then close SQL Server Managent Studio.

You are now ready to setup the backup job in Nordic Backup Pro.
Add the Sys Admin role to the account
Open Nordic Backup Pro, then click on the "Backup Setting" button at the bottom. Open Backup Settings to configure a new job


At the top of the Backup Setting screen, click on the Plus sign to start a new backup set.

Nordic Backup is designed to maintain a separate backup job for each type of backup (File, Database, System State, etc.) and run them simultaneously if their backup times overlap.
Click the plus sign to add a new job
Set a descriptive name for the backup set, for example SQL backup. Change the backup type to ‘MS SQL Server Backup’. Then the SQL server connection info will appear below the Backup Set information. This specifies the server and login information to connect to the local server.

**By default, it will be populated with the local server name and SA account, however it is important to change the account information to the account your previously setup within SQL. Click “Next”.**
Set a name and change the backup type to MS SQL Server Backup
Select the databases to backup by clicking on the box next to it, then click “Next”.

**If there are no databases shown, an incorrect Login ID or Password was supplied in the previous screen.**
Select the databases to backup
Set the schedule options for the database backup set. By default, the Transaction logs are scheduled to be backed up Monday through Thursday at 21:00 hours (9pm). The full database backup is scheduled on Fridays at 21:00 hours.

To modify these schedules, click on the schedule and then click “Properties”. If the database you are backing up is less than 1 GB in size, it is not necessary to perform the "Transaction Log Backup". Remove the schedule for the transaction log backup, then modify the "Database Complete Backup Schedule" to run every day.
Assign a schedule to the backup set
Change backup times and days to run as you would like. We recommend running the transaction log backups several times a week and the full database once a week.

Click “Ok” when done, then “Next” in the New Backup Set Wizard.

Note: You can have more than one schedule in a backup set, i.e. you can perform intra-day transaction log backup by adding more than one daily transaction log backup schedule to your backup set.
Customize the settings of the schedule


On this screen you may set the encryption for this backup set. You can choose between “Default” and “Custom". If you choose "Default” your files will be encrypted with the password you use to log into the Nordic Backup Pro.

**Note that the encryption key then is fixed and does not change if you subsequently change the password of your account.**

We recommend that you select "Custom" and enter an encryption key of your choice in the 2 bottom boxes. It is important that you choose an encryption key which only you know, thus assuring that you are the only who can access your files through Nordic Backup.

**Please note that your databases cannot be restored without the encryption key. It is important that you keep it in a safe location, in case you lose your computer.**

We recommend that you select the following options for encryption:
  • AES algorithm
  • CBC mode
  • 256 bits
  • Your encryption key must be at least 8 characters including upper case letters and lower case letters and at least one number.
Click "OK" to continue.
Set your encryption key to secure your data
Click "OK" to finish creating the backup set. Click OK to complete the backup set

After the SQL backup set has been created, there are some advanced settings to check. You will need to ensure that the temporary location for storing the backup has enough free space and is not included in a regular file backup. You should also verify the Retention and In-File Delta settings.

By clicking the "Backup Settings" button on the main screen, you can see and change settings for each backup set.
Adjust Backup Settings

In the "Backup Setting" screen you can adjust any of your backup sets. To select which set to change, click on the drop down arrow button on the main screen, you can see and change settings for each backup set.
Select the backup set to change

Here you can select the folder for temporary files. We recommend that you select the drive which has the most free disk space.
Set options for backups
Retention policy

Retention is an important part of any backup because it specifies how long a changed or deleted database from the source server is retained on the backup server. By default, Nordic Backup is configured to retain data for 7 days. However, Nordic Backup Pro can retain all changes for as long as you want, but be advised that all data is counted toward your backup quota. If you would like to increase or decrease your data storage limit, it can also be managed through the Nordic Backup website at any time.

We recommend you set Retention time to 30 days minimum.
Adjust retention time of files backed up


In-File Delta

Delta Block mode is very suitable for backup of large files, as it only takes backup of the changes in the file itself. Even if a file is 1 GB, it can easily change as little as 50 MB. After the initial full backup, changes are then the only part of the large file that is backed up.

We recommend that you adjust the default settings by clicking on the "Advanced" button.
Change Delta Block settings for large files
Adjusting the In-File Delta settings are recommended due to constant changes of the database. As the database is backed up with the In-File Delta technology, the default of 100 delta backups will be created before the original file is uploaded again.

By setting a monthly override of the delta upload, it ensures that the database will be backed up in full at Nordic Backup. Another benefit of the monthly override is to reduce the number of delta blocks and reduce the restore time.

Check all the boxes for each month then select the radio button for the specific day. We recommend choosing the last weekday of the month.
Adjust advanced settings for a monthly full backup
US v1.0
You have now completed the configuration of Microsoft SQL Server backup set in Nordic Backup Pro.
Terms & Conditions                 Payment & Refund Policy                 Privacy Policy                 Kontakt                 Agent Program                 Site Map