How to Uninstall an Instance of SQL Server?
SQL Server is a Relational Database Management system that was developed and marketed by Microsoft. In this article, we will look into how to uninstall an instance of SQL Server setup:
- To uninstall SQL Server, you need to have local administrator permissions.
- Back up your data. You could create full backups of all databases, including system databases, or manually copy the .mdf and .ldf files to a separate location.
- Stop all SQL Server services.
- To start the removal process from Windows Server 2008, Windows Server 2012 and Windows 2012 R2 navigate to the Control Panel, then select Programs and Features.
- Right-click Microsoft SQL Server (Version) (Bit) and choose Uninstall.
- To start the removal process from Windows 10, Windows Server 2016, Windows Server 2019 navigate to Settings from the Start menu and then choose Apps.
- Search for SQL within the search box, select Microsoft SQL Server (Version) (Bit). As ab example, Microsoft SQL Server 2016 (64-bit) shown below:
- Select Uninstall.
- Select Remove on the SQL Server pop-up dialog box to launch the Microsoft SQL Server wizard.
- Use the drop-down to select Instance, mark the SQL Server instance name, or the option to remove only SQL Server shared features and management tools. To continue, select Next.
- On the Select Features page, choose the features which required to be removed from the instance of SQL Server.
- On the Remove page, preview the list of features and components which will be uninstalled. Click Remove to start the un-installation.
- Refresh the Apps and Features window in Windows 10, Windows Server 2016, Windows Server 2019, or Programs and Features in Windows Server 2008, Windows Server 2012 and Windows 2012 R2 to verify the SQL Server instance has been removed with success.
Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course by GeeksforGeeks.