Post reply

Enterprise Edit or Standard

  • April 1, 2010 at 4:39 am

    #217366

    Hi All

    I have always thought that you can only use Enterprise edition when setting up mirroring but have been looking on the web and it appears im wrong. Was this the case for clustering? Are there any problems when using standard edition for mirroring?

    Any help will be gratefully received!

    Thanks in advance.

  • April 1, 2010 at 4:56 am

    #1143818

    yes you can use standard edition for mirroring i have used it for a couple of years without any issues.

    Also when you are using mirroring, you do not need neccesarily need a license for the mirrored server

    When doing failover support, a server is designated as the passive server. The purpose of the passive server is to absorb the data and information held in another server that fails. A passive server does not need a license if the number of processors in the passive server is equal to or less than the number of processors in the active server. The passive server can take the duties of the active server for 30 days. Afterwards, it must be licensed accordingly.

    http://www.microsoft.com/sqlserver/2005/en/us/Special-Considerations.aspx"> http://www.microsoft.com/sqlserver/2005/en/us/Special-Considerations.aspx

  • April 1, 2010 at 5:14 am

    #1143829

    Thanks very much that helps alot.

    Would you happen to know if i have a x64 server with standard edition on it currently and we want to use it for another system can i put enterprise manager on the server also?

    Thanks!

  • April 1, 2010 at 5:19 am

    #1143832

    I think that you can install Enterprise as another instance, but I am not sure. maybe someone else will know for sure

  • April 1, 2010 at 1:53 pm

    #1144441

    Yes you can install up to 50 instances of Enterprise edition on a single server.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • April 1, 2010 at 3:06 pm

    #1144483

    Thanks for your reply, can this be done even with SQL standard edition already installed on the server?

  • April 1, 2010 at 3:11 pm

    #1144490

    If standard is already installed, then you would have 49 instances remaining for enterprise edition.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • April 1, 2010 at 3:13 pm

    #1144492

    Thanks for your help its much appreciated

  • April 1, 2010 at 3:16 pm

    #1144499

    you can install standard and enterprise together under one license, however I would expect that would have to be an enterprise license.

    mirroring - with standard edition you can only do synchronous (high safety) mirroring. I've never found that a problem but the network should be fast and the databases not too far apart.

    clustering - standard edition only allows two nodes.

    ---------------------------------------------------------------------

  • April 1, 2010 at 3:19 pm

    #1144502

    You're welcome.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 10 posts - 1 through 9 (of 9 total)

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