Post reply

Database Expansion on 2 node Failover Cluster

  • June 22, 2009 at 8:20 am

    #211203

    If I expand the database on the Active node will the other node expand the database automatically or do I have to do it on both nodes?

    thanks,

  • June 22, 2009 at 8:31 am

    #1013326

    There is only one physical database... when you fail over, SQL Server is stopped on node 1, the disks containing the database are moved across to node 2, and then SQL Server is started up on node 2.

  • June 22, 2009 at 9:38 am

    #1013399

    Note that you perform these operations on the virtual node, not either instance. If you do that, most things work across both nodes.

    Note that as mentioned above, there is only one database. A cluster has "shared storage" meaning that there is only one set of disks accessed by both nodes.

  • June 24, 2009 at 10:26 am

    #1014771

    Thank you.

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

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