Adding & Removing SQL Features via Command
Adding & Removing SQL Features via Command
This is a quick guide on how to add and remove features from SQL Server via command, following the theme of recent posts.
The following areas will be covered within this post;
# Check Features Installed on a SQL Server.
# Installing a SQL Server Feature (Replication) via Command.
# Uninstalling a SQL Server Feature (Replication) via Command.
Check Features Installed on a SQL Server
A mounted SQL Server ISO is required for us to first RunDiscovery.
![SQL Server Run Discovery via Command](https://peter-whyte.com/wp-content/uploads/2019/07/mssql_setup_rundiscovery.png)
That’ll only take a second, and once done we can view the contents of the Summary.txt file to see the discovery result.
![SQL Server RunDiscovery Summary File](https://peter-whyte.com/wp-content/uploads/2019/07/mssql_discovery_summary_file.png)
Installing a SQL Server Feature (Replication) via Command
The command below should be straight-forward enough to understand. See Microsoft’s documentation for more information on parameters etc.
![SQL Server Install Feature via Command](https://peter-whyte.com/wp-content/uploads/2019/07/mssql_install_feature_replication.png)
We can verify the feature installation by running another Discovery.
![SQL Server RunDiscovery Summary File Replication](https://peter-whyte.com/wp-content/uploads/2019/07/mssql_discovery_summary_feature_added.png)
Uninstalling a SQL Server Feature (Replication) via Command
Uninstalling a feature is as easy as the installation of one. Run the command as shown below.
![SQL Server Uninstall Feature via Command](https://peter-whyte.com/wp-content/uploads/2019/07/mssql_uninstall_feature_replication.png)
And finally run another Discovery.
![SQL Server RunDiscovery via Command Removing Feature](https://peter-whyte.com/wp-content/uploads/2019/07/mssql_discovery_summary_feature_removed.png)
0 Comments