Remove Data Quality Server Objects
Applies To: SQL Server 2016 Preview
Uninstalling Data Quality Server from an instance of SQL Server, or completely removing an instance of SQL Server that has Data Quality Server does not delete some Data Quality Server objects, including the DQS databases. This implies that you do not lose your DQS data if you uninstall Data Quality Server using the SQL Server setup. You must manually delete these Data Quality Server objects after the uninstall process is complete.
If you are just uninstalling Data Quality Server from an instance of SQL Server, you must manually delete the following Data Quality Server objects from the SQL Server instance after the Data Quality Server uninstall process is complete:
DQS_MAIN, DQS_PROJECTS, and DQS_STAGING_DATA databases.
##MS_dqs_db_owner_login## and ##MS_dqs_service_login## logins.
DQInitDQS_MAIN stored procedure from the master database.
You can delete these objects in SQL Server Management Studio by right-clicking the object, and clicking Delete in the shortcut menu.
If you just uninstall Data Quality Server from a SQL server instance using the –uninstall command line parameter from the command prompt, all the DQS objects are deleted as part of the uninstall process. You do not have to delete them manually after uninstalling Data Quality Server. To uninstall Data Quality Server from command prompt, type the following command at the command prompt, and press ENTER:
If you are completely uninstalling the SQL Server instance that has Data Quality Server, you must manually delete the DQS_MAIN, DQS_PROJECTS, and DQS_STAGING_DATA databases from your computer after the uninstall process is complete. For a default SQL Server installation, the DQS_MAIN, DQS_PROJECTS, and DQS_STAGING_DATA databases files are available at C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA.