I have a SQL Database that is running 15 minute backups to a folder on the local disk. I also have a maintenance task in SQL Server that's automatically deleting any backups that are over 1 hour old. The backup folder is exposed across a network share to a second server on a cross-over cable.
Okay on server number 2 I need a way to sync the folder shared on the database server (i.e. the one containing the rolling 15 min backups) to a local folder. This will completely isolate the files away from server 1 to give me some recovery options should server 1 fail.
Can anyone recommend a light weight folder syncing application to run on server 2 so that I can mirror the contents of the network folder to a local folder? Kind of like Dropbox but between a local folder and a network share.
So far I've tied myself in knots writing a DOS command file to copy across the new files and delete the old ones. I've tried to hook it up to a Task Scheduler but am running into endless permission problems. The actual command file runs perfectly when manually invoked, but automating it is proving difficult.
I have now solved this problem by backing up directly to the network share. I was having trouble with this previously due to the the Network Service account not recognising the share address. In the end I solved it using the method here: http://www.howtogeek.com/51788/how-to-backup-sql-databases-to-a-network-share/