In this article you will find a perfect way to uninstall a stand-alone instance of SQL Server 2014.
Pre-requisites to uninstall an SQL Server instance:
- You must login system as local administrator with permission to log on as a service.
- You must have minimum amount of physical memory with enough page size. ( page size = 2 times of physical memory )
Important points to be consider before uninstall SQL Server 2014:
- Backup your database.
- Drop/Delete local security groups.
- All SQL server services must be stop. This would leads to successful removal of SQL Server.
Note:
Manual action: We need to uninstall SQL Server Browser component, if you want to uninstall all components of SQL Server 2014.
To uninstall SQL Server instance, go to Control Panel and then Programs and Features.
How to uninstall SQL-Server 2014 – Control Panel
Select and right-click on Microsoft SQL Server 2014 and select Uninstall/remove.
How to uninstall SQL-Server 2014 – Programs & Features
Click on remove.
How to uninstall SQL-Server 2014 – SQL Server 2014 – Remove
How to uninstall SQL-Server 2014
Select instance & click next.
How to uninstall SQL-Server 2014 – Select Instance
Select features you want to uninstall:
How to uninstall SQL-Server 2014 – Select Features
Verify Ready to remove wizard, click Remove.
How to uninstall SQL-Server 2014 – Ready to Remove
Removal in Progress:
How to uninstall SQL-Server 2014 – Removal Progress
Congratulations, SQL Server 2014 is completely removed.
How to uninstall SQL-Server 2014 – Complete
Reboot your system if possible.
By above method, we can uninstall SQL Server 2014.
************************************************************************
Note: Please don’t hesitate to revert in case of any query OR feedback.
Thanking you.
Have a easy life ahead.
Hi I have installed 2 instances on SQL server 2014, if I remove one instance by using the above un installation method. Will I be able to run other instance from the sql server or not ?
I request you to be more specific on your question, I found it bit confusing,
Consider example, If you installed 2012 and 2014 SQL server (i.e. 2 instances) and you wanted to remove any one of them ( lets say 2012 SQL server) than it will be absolutely fine. Another instance (i.e. 2014)will work.
And I request you to backup your database first before doing any kind of R & D.
Jignesh, Rishi question is , he installed 2 instance , default and named instance on sql server 2014 itself. so if he wants to uninstall the named instance by using above method. will he able to run other default instance ?
so my answer is , Yes Rishi, no issues will happen but don’t un-installed the shared features while uninstall the named instance. Because shared feature are same for both the instance.
Thank you Ajitesh for adding.
/thank you!
Thank you Akki for writing.
Stay Tune. 🙂