Post reply

Failover test

  • June 11, 2009 at 4:29 am

    #210536

    Hi

    I'm involved in a failover test today, some maintainence was due to be done after we've failed over.

    The clustered SQL Server failed over to it's mirrored site (not clustered) and the mirroring was stopped.

    the windows guys were then adding new storage, something went wrong and they now have to create a new MSCS cluster. My question is how will SQL Server respond when the service is started again. All disks will be named the same and therefore databsaefiles in the same location. I'm just concerned that having to rebuild the MSCS will result in having to run SQL Setup again.

    Any advice is much appreciated.

    thanks

    Paul

  • June 11, 2009 at 5:07 am

    #1007899

    Yes if u will run MSCS for creating cluster server .... u need to install sql again..You database files will not be impacted ... you can attach uor db after installation

  • June 11, 2009 at 5:11 am

    #1007904

    You can start from here >>>> http://www.jumpstarttv.com/clustering-sql-server-2005_33.aspx

    This article is from Jumpstar TV, the author is Brian Knight ( SQL SErver MVP)

    :hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • June 11, 2009 at 5:11 am

    #1007905

    Thanks for the feedback...

    Paul

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

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