We help IT Professionals succeed at work.

Version backups of excel file.

Hi,
I wonder if someone has a good tip for me or a software that assists me on creating a version backup.
I have a customer that has a excel sheet on a shared server. The excel contains hotel reservations.
He would like to either create a backup with a time stamp every 10 minutes or whenever the file is changed. I understand this could generate thousands of copy's but this is ok for now. So there would be 144 per day, I suppose to have them sorted by day and than have a file with an added time and date to the file name. So that there is a backup every 10 minutes because he suspects that the sheet is changed by employees that erase reservations to pocket the money.
Alternatively I could also backup the file whenever it changes but this could potentially be a lot more. But it all depends that is the easiest to do here.

Any suggestions and how I could control this on a windows 2003 server.

Thank you for taking the time to assist me in finding a possible solution for this.

Best wishes,
Thom
Comment
Watch Question

Bradley FoxLAN/WAN Systems Administrator
CERTIFIED EXPERT

Commented:
Install SharePoint services on the server and enable versioning in the document library.  Drop the file there and it will keep as many versions as you set it to.  SharePoint is very easy to setup and maintain.

SharePoint Download
http://technet.microsoft.com/en-us/windowsserver/sharepoint/bb400747

Getting Started Guide
http://technet.microsoft.com/en-us/library/cc288558(office.12).aspx

Enabling Versioning
http://technet.microsoft.com/en-us/library/cc288279(office.12).aspx
Hi Thom

In my thinking a very easy solution is to use SOS online Backup. It keeps unlimited versions and you can set how often it syncs. It costs $9.95 a month for a 100GB or $129.95 for two years with a 50GB account. Only the changes made to the file size add to your backup so if the original file doesn't get bigger than you don't get charged for extra storage. In other words unless it is a massive (and I mean massive!) excel file don't think you will ever exceed 50GB. The web address is http://www.sosonlinebackup.com. Hope this helps. Take care.

Gareth
Commented:
Microsoft Data Protection Manager 2010 to the rescue - it's Microsofts backup program does what you want it to do and the sweetest aspects is that you can integrate it with AD where users can actaully restore their own files (versions from backup.  
SharePoint is great for maintaining versions (both major and minor), SharePoint Foundation 2010 is free, and it provides many, many other benefits to an organization.  However, if you aren't already running SharePoint, I would not consider installing it only for version control on a limited scope.  It is an Enterprise level application and can have far reaching implications.  If it gets "out" into your organization without a defined implementation and governance plan, you could be biting off way more than you want to chew.  Plus, if you are not running an instance of SQL Server (2005 SP3+ at least), you'll have to install it standalone (SQL Express w/ 4GB limit) which is NOT what you want to do if your organization ever wants to really use SharePoint, because you won't be able to scale out a larger installation.

Just my opinion.
There are other options too, perhaps using free back-up software like comodo or Fbackup.

I admit I've not used either of these, although I do use other back-up solutions (SpiderOak - but I admit that I get additional space for referrals on that one) and also mercurial versioning for all of my work but I'm not sure that's really the kind you need.
Regards,
Philip
Or, I meant to add, you could simply add a simple macro to the file like this, but add both timing and timestamp for it.
Regards
CERTIFIED EXPERT
Commented:
Thomanji,

The problem with using a full file (or just sheet) backup to detect fraud is the processing that has to be done afterwards to check back through them.

What about a macro that adds to a text log file each time a reservation is made (or canceled)?

Regards,
Brian.
It seems to me this is another case in an oh so very long line where Excel is being used for something it should never be used for.  If your customer is concerned with fraud, Excel is certainly not the right environment for implementation of whatever information system they have - and neither is Access.  I'm sure there are a number of "solutions" that you can devise, but Excel was never meant to be a auditable, secure transation logging system.  

Again, just my opinion.
ThomasPartner

Author

Commented:
Hi,

Thank you for all the comments it is all very helpful.

A macro is a interesting idea but of course the log could be modified. I have to look deeper into this and see if it is easy for the reservation staff to mess with it. But I think it is a thing I look deeper into, I just think it is maybe difficult to detect a deletion but something to checkout as long I can write it into a external file.

I am looking into the backups and sharepoint to save versions and will report back in a bit.

@AceOf Empire, I do agree that this is not what should be used but that is what he has at the moment and I have to deal with it. However, I totally agree that this is not the way to go into the future.

Thanks to you all, these are all very helpful comments.

Best wishes,
Thom
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

Commented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
ThomasPartner

Author

Commented:
I am sorry, I forgot this one. I have resolved the issue and I think that the distribution as outlined above is fair except I think AgeOfEmpire should bet at least 150-200 points and the rest split to the others. I tried some of the solutions but than finally made the customer understand that the best way is to go with a proper software that records a detailed audit trail as AgeOfEmpire suggested. I found a good solution using (http://www.ezeeabsolute.com/) which is not bad for the money they charge.
Thank you for all of the suggestions and responses.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.