Showing posts with label thoughts. Show all posts
Showing posts with label thoughts. Show all posts

Tuesday, March 20, 2012

3 server active cluster

Does anyone have any thoughts on how to setup and configure a SQL cluster of
three ACTIVE servers. I'm familiar with a 2 node, active/passive and
active/active cluster but have not seen much published on a 3 or 4 node
active(n) cluster. Thanks! - Mike
Hi
No different to a 2 node. The big descision you have to make is onto which
machine an instance can fail over. If you were to allow enough resouces for
one machine to handle all 3 server's instances, you have a lot of unused
resources.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike" wrote:

> Does anyone have any thoughts on how to setup and configure a SQL cluster of
> three ACTIVE servers. I'm familiar with a 2 node, active/passive and
> active/active cluster but have not seen much published on a 3 or 4 node
> active(n) cluster. Thanks! - Mike
|||I have another 3 server cluster. I want an active/passive and then a dev as a last resort for failover. The dev box is going to have either VMWare or Virtual Server because I am using this as a last resort for failover for Exchange, too.
You can call me crazy but will this work?
Kami

Quote:

Originally posted by Mike Epprecht (SQL MVP)
Hi
No different to a 2 node. The big descision you have to make is onto which
machine an instance can fail over. If you were to allow enough resouces for
one machine to handle all 3 server's instances, you have a lot of unused
resources.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike" wrote:

> Does anyone have any thoughts on how to setup and configure a SQL cluster of
> three ACTIVE servers. I'm familiar with a 2 node, active/passive and
> active/active cluster but have not seen much published on a 3 or 4 node
> active(n) cluster. Thanks! - Mike

Thursday, February 9, 2012

2005 backup scheduler

I can not see the schedule option in the backup database window of sql server 2005.
Any thoughts please?Make a new SSIS Maintenance plan, scroll down to the Mangagement node, expand, right click the Maintenance Plan node and select either New Maintenence Task or Maintenance Plan wizard. The Maintenance plan gives you the scheduling options.