Friday, March 9, 2012

Replication - Mirroring - Clustering?

Hi,
I'm not the network guy, just asking the question for him.
Here's the scenario:
We manage our own server and have a SQL 2000 database.
All database transactions are done through our website.
What the boss wants:
If one of the servers goes down, database server or the IIS server,
everything should be switched over to another server.
The data must be up-to-date at all times in the backup server.
I just need a suggestion as to the best method to implement this.
Any websites where I can get the information?For Web Servers, use NLB. Its Network Load Balancer and for database, use
MSCS Clustering.
"Raymond D'Anjou" wrote:

> Hi,
> I'm not the network guy, just asking the question for him.
> Here's the scenario:
> We manage our own server and have a SQL 2000 database.
> All database transactions are done through our website.
> What the boss wants:
> If one of the servers goes down, database server or the IIS server,
> everything should be switched over to another server.
> The data must be up-to-date at all times in the backup server.
> I just need a suggestion as to the best method to implement this.
> Any websites where I can get the information?
>
>

No comments:

Post a Comment