Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
steamngn
Constraint Violating Yak Guru
306 Posts |
 Posted - 2005-10-26 : 13:18:11
|
| Have a small business that has 2 SQL based apps. They are looking to get some sort of simple failover protection setup. This company has 20 workstations, and does not want to spend for clustering unless need be. Currently there are two identical servers at this location, so hardware is fine, but the apps they are running will not support msreptrans columns, so I was looking at software based replication stuff. Anyone using Peer or Xlink or some other brand? Looking for opinions/ideas before I jump in to help these people...AndyThere's never enough time to type code right, but always enough time for a hotfix... |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-26 : 22:00:01
|
| from the workstations you can do updates to both servers, so both of them becomes a repository of data while the other will be your 'active server'if you need to modify the data on the active server, create a program that will do the job and have that program update both servers...HTH--------------------keeping it simple... |
 |
|
|
steamngn
Constraint Violating Yak Guru
306 Posts |
Posted - 2005-10-27 : 07:17:49
|
Hi Jen,I thought about going that route, but this company has no formal I.T. department. If something goes wrong, they will be on their own until I (or someone) can get to them. I've never really used any 3rd party software like this, but it looks pretty good on the cover. I may download a trial of xlink and then post my findings here for everyone to laugh at .AndyThere's never enough time to type code right, but always enough time for a hotfix... |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-27 : 22:41:51
|
| how about a simple backup and restore from the active to the passive server?you can create a job for them at the passive server to restore the backup file periodically, updating it, or something like log shipping?--------------------keeping it simple... |
|
|
|
steamngn
Constraint Violating Yak Guru
306 Posts |
Posted - 2005-10-28 : 07:08:51
|
| I've got that running now, and was my original recomendation. The problem is this company is located quite a ways away, and this is giving the owner a little bit of the heebie-jeebies. They really can't justify a true cluster environment, but they are concerned that the failure of the primary server will leave them in a lurch for too long a time before the passive server can be brought up. Some of this fear is definitly overkill, but I am obligated to show them the options. I've never even heard of some of this software, but after some homework it looks pretty enticing. This Xlink stuff not only creates a virtual cluster for the DB but also does a cluster-type replication of all shared folders. Pretty cool. I'm not sure what kind of maintenance/overhead this software would add, seems too easy on the first look...AndyThere's never enough time to type code right, but always enough time for a hotfix... |
|
|
|
|
|
|
|
|
Replication software thoughts?