Hi all,
we want to create a offsite redundant server which can be a standby machine if something happens to our primary machine, any input how to do this over internet? what type of bandwidth we need, and for security ssl or vpn? or anything i missed thats important to consider. Plans are to use sql server 2005. Thanks all
Well, there are a lot of options here:
1. "What type of bandwidth do we need?" Depends entirely on your load, specifically how much you log. So, find out how much you log at your peak and that should be the minimum bandwidth. Currently, I have an interstate deployment running in asynch mode, and they are doing well. There is not a backlog until they start to rebuild their indexes, at which point there can be a buildup of several GBytes. The solution to that is to rebuild the indexes less often.
2. Database mirroring has encryption built in.
3. "Anything else?" If you are trying to get automatic failover and running on the internet, then I would be worried that a surious or glitchy network would cause unwanted automatic failovers.
Thanks,
Mark
No comments:
Post a Comment