I prefer to do things as cheaply as possible, but not at the expense of the thing not working at all. I have a customer who uses windows backup as thier primary backup solution. This works great using the normal tape type method. The customer has a lot of documents, which are updated and changed on a daily basis.
What happens if a month down the road after working on a document they go to work on it again to find that previous information has gone. The backup tapes will not help as they will have only have changes from 2 weeks ago. What the customer really wanted was to backup different versions of the files daily and they did not want to use the windows backup to extricate the file * .bks. So I thought I would knock up a script to run robocopy to copy these file to another location.
Not quite! The customer also has a lot of pst files for each project and robocopy can’t copy these as they may be open. Time to think of something else.
Now some of these files can be quite big (100mb or more) and saving these to a different location on the server will use up precious space. So l decided to get a NAS/SAN box. They had a free Netgear on kicking around, but getting the thing to work was a nightmare (problems with driver software), So we built one. We used an old Dell PC (not that old) installed a cheap sata disk controller (£13) and istalled 3 500MB disk.
The OS/Software we used to set the whole thing up is OpenFiler , which created a RAID 5 volume and create an iSCSI drive for the main SBS2003 server to connect to using the iSCSI Software Initiator to create a logical drive. 1TB NAS/SAN server on the cheap.
Though I still had a problem backing up pst files. Hobocopy to the rescue. Hobocopy uses the Volume Shadow Service (VSS) to “snapshot” the disk before copying. It then copies from the snapshot rather than the “live” disk. Perfect just need to work out how to save versions of files.
Once I saved a full backup and created a ’statefile’ to read from, I just used hobocopy to do an incremental copy of a folder to another folder prepended with the date (ie 20080103.data.) on the NAS server and this folder would only have the directory structure and files which have changed, Although you will have to get rid of the ‘thumbs.db’ as well or you end up with loads of empty folders.
Using the following in a batch file (run daily) with some VB scripts to clean up the directories and blat to email the daily results to the customer and myself, all seems to be working well.
REM: Set Backup Date
SET yyyymmdd=%DATE:~6,4%%DATE:~3,2%%DATE:~0,2%
“C:\hobocopy\hobocopy.exe” /statefile=generaldata.xml /incremental /verbosity=2 /skipdenied /y /r “D:\Data” “O:\%yyyymmdd%.Data” >> hobolog.txt 2>&1
Cheap as chips. You tight arse