New instance on a failover cluster

  • Hi,

    I have created a SQL Server 2005 failover cluster, now I need to add a new instance to it, but I am a bit un-clear about the following:

    1. Would I need a new virtual name and virtual ip for the new instance?

    2. I have a separate lun allocated for the new instance, does it need to be in a different cluster resource group?

    3. Is there anyway to use my current cluster name for the new instance, i.e., [Current Instance Name]/AppsDB?

    4. Would I need to re-run Service Pack for the new instance?

    Regards,

  • Please help me out here, I'll be much obliged...

    Regards,

  • 1. Would I need a new virtual name and virtual ip for the new instance?

    Yes

    2. I have a separate lun allocated for the new instance, does it need to be in a different cluster resource group?

    The disks need to be in the same resource group as the SQL Server instance and SQL Server resource must have a dependency to the disk resource. Any shares used by the SQL Server, such as for backups or log shipping, also must be in the the same resource group.

    3. Is there anyway to use my current cluster name for the new instance, i.e., [Current Instance Name]/AppsDB?

    No

    4. Would I need to re-run Service Pack for the new instance?

    Yes - each SQL Server instance is completely separate from the other instances including all of the "binaries"

    SQL = Scarcely Qualifies as a Language

  • Thanks Carl... much appreciated!!!

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

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