There may be situations that you need to add a new DB instance to one of your production DB's or remove an instance with the purpose of relocation DB's.
Adding and instance or removing an instance is very straight forward if you follow the installation set up wizard. Also you can use below links to refer for knowledge.
Remove:
https://docs.microsoft.com/en-us/sql/sql-server/install/uninstall-an-existing-instance-of-sql-server-setup?view=sql-server-2017
Add feature:
https://docs.microsoft.com/en-us/sql/database-engine/install-windows/add-features-to-an-instance-of-sql-server-setup?view=sql-server-2017
However most expensive question is whether the DB server need a restart after adding or removing an instance. What is the knocked on effect on production DB server. I have done this many times in my life and you can add or remove an instance without a DB restart. There is no impact to the other instances on the SQL server. However i would recommend taking a snapshot before performing any action to mitigate any risks.
Hope this answers!
No comments:
Post a Comment