SQL Server Performance

SQL Server 2005 - Uninstalling cluster and nightmare of tasks you need to observe!

Discussion in 'SQL Server Knowledge Sharing Network (SqlServer-qa' started by satya, Feb 3, 2008.

  1. satya Moderator

    One of the SSP member gujsa01 has posted his realtime experience about uninstalling cluster on SQL Server 2005, its worth going through this post that will guide you through such issues!
    Upon installing new 64bit iSCSI SQL Server 2005 EE Cluster, vendor suggested ( wasn't documented in their readme file) I should change the NTFS block size on the partition to 64K. The following article helped with understanding the defaults:
    http://technet.microsoft.com/en-us/library/bb457112.aspx
    Steps involved uninstalling cluster:
    1. Snapshot the volumes. (Data/Backup/Log)

    2. Uninstall SQL Server including Integration Services, SQL VSS Writer, SQL Browser, Setup files

    3. Delete disk resources from the nodes.
    4. Restart nodes.
    Within Disk Management on these nodes, made changes to Logical Volumes by right clicking on each-> Select Format-> Change the Allocation Unit Size to 64K and was ready to install SQL Cluster. Added the disks back into their respective Resource groups, performed Manual fail over, worked fine.

    Started the SQL Server install process, got stalled half way. From various posts that I read suggested the install takes a bit longer. My wait time exceed over 30 minutes and still the progress bar showed no signs of progress. So I decided ( BIG MISTAKE!!!) to cancel the install which triggered the fun part ..
    Apparently it appeared that the "uninstall" worked and was ready to run the setup after reboot. Kept on getting the following error:
    "The Setup has encountered an unexpected error in datastore...". Found the following link which corrected the issue:
    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=354408&SiteID=1
    Once SQL Server was installed successfully:
    1. Applied SP2 on each nodes being an ACTIVEACTIVE cluster
    2. Mounted snapshot volumes.
    3. Within iSCSI initiator, "loaded" these targets from the "Target" tab by clicking refresh. Logged the volumes into the cluster nodes

    4. Within Disk Management assigned letter to this new volume by right clicking on it and selecting "Change drive letters and paths".
    5. Stopped SQL Services from with each node using Cluster Administrator by getting them offline.
    6. Renamed existing "Microsoft SQL Server" folder from the shared resources. Copied the folders from the newly loaded snapshot volumes into the respective drives (Data/Log/Backup).
    7. Restarted SQL Services.
    8. Logged in SSMS, confirmed all the user databases are listed, ran CHECKDB on each.
    9. Moved resources between the Cluster groups successfully.
    Hope no one has to go thru this but if u are facing the incomplete uninstall issues, this might help resolve the issues related.
    Thanks





Share This Page