| Author |
Topic |
|
stevehewitt
Starting Member
3 Posts |
 Posted - 2005-09-26 : 09:59:43
|
| Which is the best approach with regards to the mirror of data from one server to another.My first option is to use the replication service available in SQL.what I need to know here is what are thr pro's and the con's of using this method.My second option is to use a third party software such as Double Take. Again what would be the pro's and con'sI will not be using cluster service or any hardware high availability.answers on a postcard. |
|
|
Sharky
Starting Member
23 Posts |
Posted - 2005-09-26 : 10:51:21
|
| perhaps a third option could be log shipping? http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part4/c1361.mspx |
 |
|
|
stevehewitt
Starting Member
3 Posts |
Posted - 2005-09-26 : 11:25:57
|
| We have considered ship logging. For now I need to look at the first two options I have, with the ship logging as a final step. |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-09-26 : 11:57:47
|
| What about failover clustering, or are we talking about a remote machine?Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda> |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2005-09-26 : 12:23:32
|
| Why go for a third party tool when there is replication?1. How big is the DB?2. What is size of the transactions?3. How much data you can afford to lose?------------------------I think, therefore I am - Rene Descartes |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-09-26 : 13:49:20
|
| Don't replication only come with Enterprise Edition?I'm guessing there's a cost savings by not doing an upgrade and just buying a slightly cheaper 3rd party tool.Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda> |
|
|
|
stevehewitt
Starting Member
3 Posts |
Posted - 2005-09-27 : 03:53:51
|
| Michael.It would be to a remote machine about 50 miles away from the primary server. We have a 2mb link between the sites, however this link would be shared with other applications. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2005-09-27 : 04:05:55
|
quote:
Originally posted by stevehewitt50 miles away .....
50 or 5000 should not make any difference! My contingency server is in a different country!!!------------------------I think, therefore I am - Rene Descartes |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-09-27 : 11:27:42
|
| I think for this type of problem, log shipping is the standard solution. Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda> |
|
|
|
|
disaster recover scope