Rick Tuhimata - DataLock Support
posted this on September 08, 2009 11:50 am
DATA FROM THE SQL DATABASE WILL BE BACKED UP TO A TEMPORARY DIRECTORY BEFORE BEING SENT TO THE [DATALOCK SERVER]. PLEASE MAKE SURE YOU HAVE SUFFICIENT SPACE ON YOUR SERVER TO STORE THIS DATA WHEN YOU RUN THE BACKUP JOB.
TIP: HAVING THE TEMPORARY DIRECTORY ON DIFFERENT HDD'S THAN THE DATABASE INCREASES I./O AVAILABILITY AND WILL SPEED THE BACKUP PROCESS UP SIGNIFICANTLY
TIP: MAKE SURE THE WINDOWS SERVICE "Online Backup Scheduler" HAS BEEN GIVEN SPECIFIC ADMINISTRATIVE LOG IN CREDENTIALS (more on this later in the article)
i. Open DataLock Online Backup
Right click DataLock Online Backup icon available in the system tray and choose [Open]
ii. Create a backup set
a. To start setting up backup sets, click the button to open the [Backup Setting] dialog.
b. On the left panel, press the button to create a new backup set.
c. On the dialog, choose [MS SQL Server Backup] as the [Type].
d. Enter a name for your backup set
e. Enter the Microsoft SQL Server administrator username and password
f. Select the database(s) you want to backup
g. Set the backup schedule for full database backup and transaction log backup
(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)
(Note: If performing a DataDump to External HDD, please untick the "Run scheduler on this computer" box. Leave unticked until you hear from DataLock with specific instructions to enable the scheduler. Failure to untick this box will result in the Exchange database being upload via your clients internet connection.
h. Set the encryption algorithm, encryption mode and encrypting key for this backup set
(Hint: For maximum security, please select AES (Advanced Encryption Standard) Algorithm, CBC (Cipher Block Chaining) mode and use an encrypting key with more than 8 characters.)
iii. Run Backup
a. Press the [Backup] button on the main page of DataLock Online Backup dialog.
b. Select the backup type (e.g. Complete, Differential, Transaction Log) you would like to perform. Select the backup set you want to run and select [Offsite Backup Server] to start backing up your files to the DataLock Backup Server. If applicable, you can change the In-File Delta Type also.
c. Click [OK] to start backing up your files to the DataLock Backup Server.
IMPORTANT:
Please change the log on credentials of the service "Online Backup Scheduler" to an Administrative User. This will ensure the backup can run, even when the computer is locked.