Post reply

Stand alone to Cluster

  • August 24, 2010 at 4:35 am

    #74307

    Hi all

    I have Stand alone server(SQL Server 2000) on Win2k3(SP2).

    Now I want make as Cluster server.

    Please suggest me a best Approch ....

    I appreciate you help

  • August 24, 2010 at 7:47 am

    #1211014

    Uninstall SQL. Configure the windows clustering, reinstall SQL as a clustered instance.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 24, 2010 at 8:59 am

    #1211082

    Hello Gail Shaw thanks for reply.

    You mean

    1.Uninstall SQL Server 2000

    2.Update Windows 2003 with Cluster (Treat as Node1)

    Is it ok..

    If I did uninstall SQL Server my data file and log files will in the server or it got delete?.

  • August 25, 2010 at 4:37 am

    #1211526

    Data files will still there be on the drive. But please take the BACKUP of database on SQL Server before uninstalling. As mentioned by Gail, configure Windows Cluster and then install SQL Server on the cluster. Then restore the databases.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

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

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