Post reply

Create a DB on a cluster.

  • March 11, 2009 at 5:59 am

    #155398

    I have a installer setup, which installs a particular DB in a SQL server.

    Now, letus say I have a 2 node active/passive cluster environment.

    And also I have installed SQL 2005 fail over cluster in that cluster environment.

    now, please answer my following questions.

    1. Do I need to run the setup once with the Logical server name

    or Do i need to run the setup in each node of the cluster with actual instance name.

    why i am asking this question because, in fail over server, the storage is common for all the node instances.

    so, will it throw an error, in the secind node when i try to run the DB scripts from the node 2 SQL server.

    thanks,

    Regards | Enbee

  • March 11, 2009 at 11:08 am

    #957696

    When you install SQL Server Clustering services and tell it the nodes that will be joined in partnership the installer will automatically install the required SQL Service Component on the second node you do not have to.

    Only thing you will have to install manually on second node is SSMS tools, etc. if you install those on your servers.

    Thanks.

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].

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

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