June 28, 2011 at 11:09 am
Hello. I have a project to sync file system images in 53 directories on our production database server with a new failover Database server using SQL Server 2008. It would be nice to sync within 15 minutes of each other. Not critical, but would like the best performance. I would appreciate anyone's response.
June 28, 2011 at 11:33 am
I depends on how much data, not how many directories and whether your fail over database should be hot or in standby.
June 28, 2011 at 11:51 am
I have 53 directories with 10,000 images each. I have been reading about Robocopy. Are you familiar?
June 28, 2011 at 12:18 pm
Robocopy may work. I used it years ago, but I believe it worked for just this kind of work.
There are lots of options these days in the cloud, but for 10k images, I'd look for something local. Are all things in one folder?
DFS (distributed File system) in Windows used to do this for us moving images of folders around to different places.
June 29, 2011 at 10:15 am
Nice, 530,000 files. Robocopy could handle the volume but it most likely does a simple stat on the source and destination files to decide if it needs to replace the destination, and then it copies the entire file over if it determines there's a difference. Depending on the connection speed and how many images change in a 15 minute period and a few other things coming to mind it's possible that robocopy will take longer than 15 minutes just to run through that many files once.
Something like DFS will be aware of what specific files change, and it even gets more granular knowing which bits of those files change, so it only replicates the absolute minimum data necessary to keep everything in sync.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply