Skip to content

Latest commit

 

History

History
42 lines (30 loc) · 4.37 KB

remove-data-quality-server-objects.md

File metadata and controls

42 lines (30 loc) · 4.37 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic
Remove Data Quality Server Objects
If you uninstall Data Quality Server from an instance of SQL Server, some Data Quality Server objects, including the DQS databases, must be deleted manually.
rwestMSFT
randolphwest
03/14/2017
sql
install
conceptual

Remove Data Quality Server Objects

[!INCLUDE SQL Server -Windows Only]

Uninstalling [!INCLUDEssDQSServer] from an instance of [!INCLUDEssNoVersion], or completely removing an instance of [!INCLUDEssNoVersion] that has [!INCLUDEssDQSServer] does not delete some [!INCLUDEssDQSServer] objects, including the DQS databases. This implies that you do not lose your DQS data if you uninstall [!INCLUDEssDQSServer] using the SQL Server setup. You must manually delete these [!INCLUDEssDQSServer] objects after the uninstall process is complete.

Note

  • Before uninstalling [!INCLUDEssDQSServer], consider backing up all your existing knowledge bases by exporting it to a .dqsb file, and use the file later to import all the knowledge bases back to a new [!INCLUDEssDQSServer] installation. Exporting and importing of all DQS knowledge bases can only be done by running DQSInstaller.exe with appropriate command line parameters from the command prompt. For more information, see Export and Import DQS Knowledge Bases Using DQSInstaller.exe.
  • Before deleting the DQS databases, consider backing up the databases if you want to preserve it, and use it later for restoring the data. For information about doing so, see Manage DQS Databases.

Uninstall Data Quality Server from a SQL Server Instance

If you are just uninstalling [!INCLUDEssDQSServer] from an instance of [!INCLUDEssNoVersion], you must manually delete the following [!INCLUDEssDQSServer] objects from the [!INCLUDEssNoVersion] instance after the [!INCLUDEssDQSServer] 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.

Important

If you just uninstall [!INCLUDEssDQSServer] 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 [!INCLUDEssDQSServer]. To uninstall [!INCLUDEssDQSServer] from command prompt, type the following command at the command prompt, and press ENTER:
dqsinstaller.exe -uninstall

Uninstall SQL Server Instance Containing Data Quality Server

If you are completely uninstalling the [!INCLUDEssNoVersion] instance that has [!INCLUDEssDQSServer], 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 [!INCLUDEssNoVersion] 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.

See Also

Uninstall an Existing Instance of SQL Server (Setup)
Uninstall SQL Server 2016