SQL Server Uninstallation

Today, we’ll talk about how to uninstall a standalone SQL Server instance.

Considerations :

  • To uninstall SQL Server Successfully, you must have a local administrator permissions to log on as a service.
  • Increase the size of the page file to two times the amount of physical memory if the computer has a minimum required amount of physical memory. An incomplete SQL Server uninstall can occur if there is insufficient virtual memory or if there is no memory available.
  • If a system has numerous instances of SQL Server, the SQL Server browser service is only uninstalled for the last instance of SQL Server. The SQL Server Browser service can be manually uninstalled from the Control Panel’s Programs and Features.
  • The tempdb data files that were added during the installation procedure are deleted when SQL Server is uninstalled. If files with the name pattern tempdb mssql *.ndf exist in the system database directory, they are destroyed.

Preparation :

  1. Back up your data. Create a FULL Backup of all databases, including system databases, or manually copy the .mdf and .ldf files to a separate location. The master database which contains all system level information of the server, which are logins, and schemas. The msdb database contains jobs information which are like SQL Server agent jobs, backup history, and maintenance plans. The following database files need to save:
    • master.mdf
    • msdbdata.mdf
    • Tempdb.mdf
    • mastlog.ldf
    • msdblog.ldf
    • Templog.ldf
    • model.mdf
    • Mssqlsystemresource.mdf
    • ReportServer[$InstanceName]
    • modellog.ldf
    • Mssqlsustemresource.ldf
    • ReportServer[$InstanceName]TempDB

2. All SQL Server services should be stopped. Uninstall SQL Server components before you begin. Active connections can prevent us from successfully uninstalling SQL Server. It is always advisable to disable SQL Server services.

3.Make use of a Login account with the appropriate permissions. Use the SQL Server service account or another account with equivalent access to RDP to the server. You can RDP to the server using a Login account that belongs to the local Administrators group, for example.

Uninstall (Windows 2008 – Windows 2012 R2):

Follow these procedures to uninstall SQL Server on Windows Server 2008, Windows Server 2012, and Windows 2012 R2:

  1. To begin the uninstall process, navigate to the Control Panel and then click on option Programs and Features.
  2. here we will be listing all services which are installed on the server , Select the SQL Server Right-click on Microsoft SQL Server (Version) (Bit) and click Uninstall. Example, MicrosoftSQLServer2012(64-bit)

3. Click on the option Remove for the SQL Server uninstallation, a dialog pop-up to launch the Microsoft SQL Server installation wizard opens.

4. On the Select Instance page wizard, use the drop-down box to select an instance of SQL Server to uninstall, or select the option to remove only the SQL Server shared features and management tools. then click Next to continue.

5. On the Select Features page wizard, Select or enable the check box of the features to remove from the selected instance of SQL Server.

6. On the Ready to Remove page wizard, cross check the list of components and features which are going to be uninstalled. Click Remove button to begin uninstalling.

7. Refresh the Programs and Features window to verify that the SQL Server instance was successfully removed and that no SQL Server components remain. If these components are no longer required, uninstall them as well.

Uninstall (Windows 2008 – Windows 2012 R2):

Follow these procedures to successfully uninstall SQL Server from Windows 10, Windows Server 2016, Windows Server 2019, and higher operating systems:

  1. To start uninstall process go to Settings from the Start menu and then choose Apps & features
  2. In the Search bar type sql and click search.
  3. Select the Microsoft SQL Server (Version) (Bit). For example, Example, MicrosoftSQLServer2017(64-bit).
  4. click on Uninstall.

5. Now click Remove option on the SQL Server dialog pop-up to get the Microsoft SQL Server installation wizard.

6. On the Select Instance page wizard, use the drop-down box to select an instance of SQL Server to uninstall, or select the option to remove only the SQL Server shared features and management tools then click Next to continue.

7. On the Select Features page wizard, Select or enable the check box of the features to remove from the selected instance of SQL Server

8. On the Ready to Remove page wizard, cross check the list of components and features which are going to be uninstalled. Click Remove button to begin uninstalling

9. Refresh the page Apps and Features window to verify the SQL Server instance has been successfully uninstalled, and also check if any of the SQL Server components still exist. uninstall these components as well if not needed.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.