Uninstall SQL Server 2019 Instance
While installing is straight forward with the help of the installer. The uninstaller for SQL Server is hidden under the control panel’s Add or Remove Programs. Once you find the option go to SQL Server and right following that you can follow the video tutorial which I have shared in the video attached here.
Now when you are uninstalling SQL Server 2019, instance make sure that you do not uninstall all the shared components which are installed on your SQL Server because, if you have another instance installed on the same server, you may accidentally delete the component that is using make it not operational.
Here are the best practices which I follow while I install SQL Server 2019.
- Always install SQL Server on the dedicated machine which is not shared with any other resource-intensive software or application.
- Make sure that antivirus is either disabled on the server or is not scanning the SQL Server data/log files
- If possible keep your data and log file on the separate physical drive while planning storage. If you are using the SAN or virtualization, the story is entirely different and I will write a separate blog post about it.
Well, that’s it for today. Please do like and subscribe to my channel. I will be frequently posting new videos which are relevant to the SQL Server world. If you want me to build video on any topic, just leave a comment on this blog post.
Reference: Pinal Dave (http://blog.SQLAuthority.com)