SQL Server Uninstallation

Today we are discussing about uninstall a stand-alone instance of SQL Server. By following the steps, you also prepare the system so that you can reinstall SQL Server.

Considerations :

  • For Successful uninstall of SQL Server, you must have a local administrator with permissions to log on as a service.
  • If your computer has the minimum required amount of physical memory, increase the size of the page file to two times the amount of physical memory. Insufficient virtual memory can result in an incomplete removal of SQL Server.
  • On a system with multiple instances of SQL Server, the SQL Server browser service is uninstalled only once the last instance of SQL Server is removed. The SQL Server Browser service can be removed manually from Programs and Features in the Control Panel.
  • Uninstalling SQL Server deletes tempdb data files that were added during the install process. Files with tempdb_mssql_*.ndf name pattern are deleted if they exist in the system database directory.

Preparation :

  1. Back up your data. Either create FULL Backup of all databases, including system databases, or manually copy the .mdf and .ldf files to a separate location. The master database contains all system level information for the server, such as logins, and schemas. The msdb database contains job information such as SQL Server agent jobs, backup history, and maintenance plans. The files that you must save include the following database files:
    • 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. Stop all SQL Server services. We recommend that you stop all SQL Server services before you uninstall SQL Server components. Active connections can prevent successful uninstallation.

3. Use an account that has the appropriate permissions. Log on to the server by using the SQL Server service account or by using an account that has equivalent permissions. For example, you can log on to the server by using an account that is a member of the local Administrators group.

Uninstallation ( Win 2008 – Win 2012 R2 ):

To uninstall SQL Server from Windows Server 2008, Windows Server 2012 and Windows 2012 R2, follow these steps:

  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).

3. Select Remove on the SQL Server dialog pop-up to launch the Microsoft SQL Server installation wizard.

4. On the Select Instance page, use the drop-down box to specify an instance of SQL Server to remove, or specify the option to remove only the SQL Server shared features and management tools. 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.

Uninstallation ( Win 2016 – Win 2019) :

To uninstall SQL Server from Windows 10, Windows Server 2016, Windows Server 2019, and greater, follow these steps:

  1. To begin the removal process navigate to Settings from the Start menu and then choose Apps.
  2. Search for sql in the search box.
  3. Select Microsoft SQL Server (Version) (Bit). For example, Microsoft SQL Server 2017 (64-bit).
  4. Select Uninstall.

5. Select Remove on the SQL Server dialog pop-up to launch the Microsoft SQL Server installation wizard.

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

7. On the Select Features page, specify the features to remove from the specified instance of SQL Server.

8. On the Ready to Remove page, review the list of components and features that will be uninstalled. Click Remove to begin uninstalling

9. Refresh the Apps 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.

Leave a Reply

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