Post reply

Uninstalling Default Instance

  • December 18, 2009 at 6:21 am

    #94227

    Hello SQL Gurus

    IN our environment, we are trying to migrate, a default instance of sql 2000 which is in cluster to a standalone box of 2008. We have one more instance on this cluster which is a named instance. our cluster Configuration is A/P cluster. I am afraid to uninstall sql 2000 default instance on this cluster group. can you please advice on what is the best practice to do this. Or is it good to uninstall the default instace at all.?

    Early replies are highly appreciated. I am answerable to Big people in my organization. Really really Scared about it. :unsure:

    exclamation:

    Thanks

    Ali

  • December 18, 2009 at 8:38 am

    #1094080

    Please someone reply...

    Thanks Ali

  • December 21, 2009 at 6:23 pm

    #1095202

    What do you mean about the default instance on a cluster? A Windows clustered server with SQL installed on the cluster should be a named instance.

    Any move of a database from one platform to another should be done with careful planning. It should be tested before changing anything on production. If the migration on the test environment works without any problems, then you can schedule to migrate off of the 2000 instance in production. Ensure you have backups before performing any changes though. A backout plan should be considered too.

    Joie Andrew
    "Since 1982"

  • December 23, 2009 at 4:09 am

    #1095858

    It is normally safe to uninstall the default instance of SQL Server and leave a named instance running.

    However, in your situation I would prefer to set the default instance services to Disabled using the Service applet, as this avoids the risk of unwanted side effects and takes less work to do.

    The only downside I can think of to this approach is if you apply any SQL fixes to the box you will have to tell the install program to update only your names instance, and not update all instances.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

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

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