Showing posts with label replicated. Show all posts
Showing posts with label replicated. Show all posts

Sunday, February 19, 2012

hand icon on replicated databases

In EM, there would be an icon of a hand under a replicated database. Did
that go away with SQL 2005 management studio?
Hello,
Based on my test, I didn't see the hand icon on replicated database.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

HA clustering with replication

Node A and Node B (sql server 2000) are being replicated to each other
serving data partitioning.
What are the options to set up HA clustering and which one is the most
economic one?
Appreciate any help.
I think you want a cluster. Here are a few guides for you:
General Clustering information
http://www.microsoft.com/ntserver/su...tering_faq.asp
http://www.microsoft.com/downloads/d...displaylang=en
http://www.microsoft.com/windows2000...ustersteps.asp
SQL Clustering
http://www.microsoft.com/technet/pro.../failclus.mspx
http://www.microsoft.com/usa/webcasts/ondemand/1883.asp (Webcast)
Now for the price issue. HA and price never agree. You can either have one
or the other.
My website also has a ton of clustering information on it.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Wen Chang" <WenChang@.discussions.microsoft.com> wrote in message
news:235AAE4A-F675-4700-8795-8E9DD7CA5DC4@.microsoft.com...
> Node A and Node B (sql server 2000) are being replicated to each other
> serving data partitioning.
> What are the options to set up HA clustering and which one is the most
> economic one?
> Appreciate any help.