How to remove in instance rrom SQLserver2012

John Lenz 1,726 Reputation points
2020-11-25T00:44:46.327+00:00

SQLserver2012
Server2012R2 Std

I have a corrupted instance and would like to remove it. What is the process?
I created a good instance on the server to replace the corrupted one.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,823 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Luis Jaramillo 1 Reputation point
    2020-11-25T01:20:48.76+00:00

    You can remove an instance from the Control Panel of Windows
    42340-image.png

    then in the wizard you can choose the instance you want to remove
    42363-image.png

    0 comments No comments

  2. CathyJi-MSFT 22,206 Reputation points Microsoft Vendor
    2020-11-25T02:24:35.363+00:00

    Hi @John Lenz ,

    Please follow below steps to uninstall SQL server 2012 instance.

    1. To begin the removal process, navigate to the Control Panel and then select Programs and Features.
    2. Right-click Microsoft SQL Server (Version) (Bit) and select Uninstall. For example, Microsoft SQL Server 2012 (64-bit).
      42284-screenshot-2020-11-25-095531.jpg
    3. Select Remove on the SQL Server dialog pop-up to launch the Microsoft SQL Server installation wizard.
      42285-screenshot-2020-11-25-094323.jpg
    4. On the Select Instance page, use the drop-down box to specify an instance of SQL Server to remove. To continue, select Next.
    5. On the Select Features page, specify the features to remove from the specified instance of SQL Server.
    6. On the Ready to Remove page, review the list of components and features that will be uninstalled. Click Remove to begin uninstalling
    7. Refresh the Programs and Features window to verify the SQL Server instance has been removed successfully, and determine which, if any, SQL Server components still exist. Remove these components from this window as well, if you so choose.

    By the way, to uninstall SQL Server from Windows 10, Windows Server 2016, Windows Server 2019, and greater, we can also uninstall SQL instance in Apps & feature (Start menu =>Setting =>Apps) as below screenshot. Then the following steps is same as uninstall SQL server from Programs and Features.
    42354-screenshot-2020-11-25-094346.jpg

    Please refer to MS document Uninstall an Existing Instance of SQL Server (Setup) to get more information.

    Best regards,
    Cathy


    If the response is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

  3. John Lenz 1,726 Reputation points
    2020-11-25T17:17:57.267+00:00

    OK,
    I went to the programs & features and navigated to the SQLserver2012 and selected remove.
    It opened the window and I selected MSSQLServer instance. It went through the removal and then opened a page and asked to remove SQLServer program. I canceled at this point and the instance is still there. Should I have gone further to remove?


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.