Post reply

Automatic Failover using SQL 2005 Standard Edition

  • June 15, 2006 at 6:37 am

    #118414

    Hi,

    I'm new to this group and to SQL Server 2005. We are in the planning stages for a new project and a question has come up about failover clustering in 2005. We are planning to use Windows 2003 Enterprise Edition with the Sql 2005 Std Edition. I've heard conflicting comments as to whether the failover clustering is automatic or manual when used with the Std Edition. I haven't found any documentation that specifically states one way or the other. Can anyone provide a definitive answer?

    Thanks in advance

  • June 15, 2006 at 7:10 am

    #643942

    Failover clustering is controlled by the cluster service, which is part of the operating system. This isn't related to SQL Server, with the exception that SQL Server 2000 Enterprise and SQL Server 2005 Standard and Enterprise make it easier on everyone by being cluster aware applications. Since you're using Windows Server 2003 Enterprise Edition, this should be handled. The cluster service can even fail-over applications which aren't cluster aware.

    K. Brian Kelley
    @kbriankelley

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply