| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2005-03-08 : 07:38:36
|
| I'm looking into keeping a hot-standby server running at another location which will be able to take over should the primary server have a hard failure. Data must be current as of the last 15 minutes before the failure.In my case, I'm currently running SQL Standard Edition, but am willing to buy a tool or upgrade to SQL Enterprise edition if it makes the job easier.Any suggested reading - white papers, books, threads, on effective ways to accomplish this appreciated. |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-03-08 : 08:15:29
|
| You could use log shipping. It's not available on standard but people have already wrote procedures that will be functionally equivalent to the stuff that you get in Enterprise edition.Otherwise you could cluster over the network if you have suitable speeds. That would be Enterprise Edition though.-------Moo. :) |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-03-08 : 08:19:01
|
| Doubt I'll have the speed to cluster.Any experience on the ease of use of SQL Enterprise versus procedures that are functionally equivalent? What about 3rd party packages that provide a functionally equivalent solution? |
|
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2005-03-08 : 08:23:41
|
What about replication?AndyBeauty is in the eyes of the beerholder  |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-03-08 : 08:33:08
|
quote:
Originally posted by SamC
Doubt I'll have the speed to cluster.Any experience on the ease of use of SQL Enterprise versus procedures that are functionally equivalent? What about 3rd party packages that provide a functionally equivalent solution?
I've not used them, though I think others have here.-------Moo. :) |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-03-08 : 08:34:36
|
| How and when did you get the handle "Grunnio"? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-03-08 : 08:38:49
|
| Is Log Shipping available in SQL 2005's "Standard" version? that would save you the [extreme] cost of Enterprise - if you can wait that long?Kristen |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-03-08 : 08:43:22
|
I was wondering about SQL 2005 and what it might offer. How long is long? I see copies of Enterprise on eBay for about $4,500 / copy - single CPU license.We should have a software sales forum here on SQLTeam  |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-03-08 : 08:43:34
|
quote:
Originally posted by SamC
How and when did you get the handle "Grunnio"?
The title was bestowed upon me around 1000 posts, which was probably about a year ago now, haven't posted much since then. It is suitably apt, given my cow fixation, and this place's yak fixation.-------Moo. :) |
|
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2005-03-08 : 08:44:45
|
Classic!! quote:
The yak's latin name is Bos grunniens, from Bos meaning Ox, and Grunnio I grunt, hence grunniens, grunting - yaks are physically unable to low or moo like other cattle
Beauty is in the eyes of the beerholder |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-03-08 : 08:51:39
|
| "How long is long?"Dunno ... but any later than December will make the 2005 name a bit daft ... "I see copies of Enterprise on eBay for about $4,500 / copy - single CPU license."Dunno about upgrade pridces, but 2005 EE is $25K/cpu, Standard $6K and WorkGroup $4KKristen |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-03-08 : 09:13:27
|
| Those are list prices. Here's a list of eBay offerings. You gotta wonder how you might get shorted buying it under $5K though. |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-03-08 : 09:15:09
|
| It was 70 degrees here yesterday. Today the wind is about 25 knots and snowing hard. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-03-08 : 10:19:13
|
| "Those are list prices"Indeed, but LIST $6K for Standard2K5 seemed pretty close to eBay $4.5K for EE2KKristen |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-03-08 : 10:29:28
|
| Aren't the first 2 items on eBay SQL Enterprise which normally list for about $20K? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-03-09 : 01:07:40
|
| SQL2K is $10K per CPU from memory, but you're right. However, what I was thinking was that the Standard version of SQL2005 looks to have the features that would most commonly be "wished for" from Enterprise SQL2K, and its much more affordable. So either it will get you a copy from a recognised source at a more affordable price, or be EVEN cheaper on eBay once it starts selling there!Kristen |
|
|
|
|
Movin' on up ...