Image by -JvL- from Flickr Creative Commons
Duplicati is an open source, powerful backup software on the cloud. It can take
backups to various storage clouds like Google drive, Amazon S3, Microsoft OneDrive,
ftp etc. It supports full and incremental backup.
OfficeClip develops free basic and enterprise edition of the Contact Manager (CRM), project management and
support ticket software suite that can be installed on private clouds like amazon Ec2.
This article will show how to backup OfficeClip sql database, documents and code files using Duplicati and amazon s3 cloud.
[more]
- Download the latest version of Duplicati on your OfficeClip server from duplicati.com and
install it on the computer where OfficeClip is installed. - Before using Duplicati to take OfficeClip backup it is important to check some settings.
This is because OfficeClip users Sql Server database which is locked when the sql server is running.
Duplicati uses Volume Snapshot Services (VSS) to get around copying locked files.- Open a windows command prompt as an administrator (right click on the icon and select Run As
Administrator) and run the command “vssadmin list providers”.
If it shows the provider as Microsoft Software Shadow Copy provider then it is running fine, skip to step 3. If it gives error, read on: - Check if the VSS Service is enabled, to do this:
- Right click on “My Computer”.
- Select “Manage”.
- Select the “Services” tree node.
- Right click on “Volume Shadow Copy”
- Select Properties
- Change the startup type to “Automatic” (Note that sometimes this service gets
- switched on automatically when VSS runs)
- Rerun “vssadmin list providers” on the command prompt as in the previous step,
if it still does not run then follow this article later on how to run duplicati using command prompt.
- Open a windows command prompt as an administrator (right click on the icon and select Run As
- Make sure microsoft visual c++ redistributable package (x64) is installed on your machine.
OfficeClip installation program installs this component. If you do not find it,
install it from the microsoft site. - Upon installation duplicati will automatically start on your windows taskbar.
Click on the icon to open the duplicati user interface. - On the Duplicati user interface click on the Duplicati wizard link to start the new wizard.
- Click on Schedule a New Backup and click Next
- Give a name to the backup and click Next
- Select Custom folder list and then select the folder where OfficeClip is installed.
If you have set the OfficeClip database manually then add that location too and click Next. - Select if you want to encrypt the backup, if you select a password then you must remember it.
Otherwise the backup cannot be recovered if you lost the duplicati settings. Click Next. - Next select a location for backup, we will select amazon S3 in this example. Click Next
- Now you will need to sign in to amazon s3 cloud to get the access id and the secret key.
Note that amazon charges a fee for storage and communication with their cloud (around $0.03 per GB/ month)
but they have a free tier that will give you around 5GB of space. Click Next - Checkmark the box that says:
- Select when and how often the backup should run
- Select when to remove the backup
- Manually override settings
- Click Next and select when to run the backup and then click Next
- Next select how many backups you want to keep and then click Next
- Scroll down to the snapshot-policy and then type required in the value field and click Next
- Verify the Summary and check mark the Run backup now checkbox
- Click on the command line tab and copy the command line text to a notepad. This is useful if the volume
shadow copy (VSS) could not be activated on your machine and you have to run duplicati from command line as
will be explained later. - There is one more step left, Volume Shadow Service(VSS) only works in administrative mode and Duplicati
runs on user mode, so we have to change this:- In file manager go to:
C:\Users\<user name>\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup
(note that the AppData folder may be hidden so you may need to type the whole string on the address bar) - Delete the shortcut for the Duplicati
- Now open the task scheduler from the control panel > Administrative Tools and use the following settings
- Create a New Task
- Set trigger to “At System Start Up”
- Set run as to Highest Privilege or as an administrator
- Set action as c:\program files\duplicati\duplicati.exe
- Restart the computer and verify from the taskbar that duplicati is running
- In file manager go to:
When VSS cannot be enabled
In some computers VSS cannot be enabled or it gives repeated error, duplicati can be run from a command prompt and setup using the task scheduler.
- Open the windows services from the Control Panel > Administrative Tools > Services
- Search for SQL Server (<instance name>) and note the name.
- Open the file in the notepad that you saved from the previous section
- Add the following lines to the beginning and the end
- net stop “SQL Server (<instance name>)”
- rest of the file
- net start “SQL Server (<instance name>)”
- Save the file with a .bat extension
- Now open the windows task scheduler from Control Panel > Administrative Tools and do the following settings:
- Set run as to Highest Privilege or as an administrator
- Set action as the program file that you just created
- Set the frequency and time of the backup
SK Dutta is a software architect and creator of OfficeClip Suite of products. He loves to design and develop software that makes people do their job better and more fun. He always explores ways to improve productivity for small businesses. He is also an avid reader in many areas, including psychology, productivity, and business.