Skip to content

Latest commit

 

History

History
72 lines (43 loc) · 3.09 KB

backing-up-and-restoring-dqs-databases.md

File metadata and controls

72 lines (43 loc) · 3.09 KB
Raw
title description author ms.author ms.date ms.service ms.subservice ms.topic
Backing Up and Restoring DQS Databases
Backing Up and Restoring DQS Databases
swinarko
sawinark
03/01/2017
sql
data-quality-services
conceptual

Backing Up and Restoring DQS Databases

[!INCLUDE SQL Server - Windows only ASDBMI]

This topic describes how to back up and restore the DQS databases.

Before You Begin

Prerequisites

  • You must know or remember the password for the database master key that you provided during the DQS server installation.

  • Ensure that there are no running activities or processes in DQS. This can be verified using the Activity Monitoring screen. For detailed information about working in this screen, see Monitor DQS Activities.

  • Ensure that there are no users logged on the DQS server.

Security

Permissions

  • Your Windows user account must be a member of the sysadmin fixed server role in the SQL Server instance to perform the backup and restore operations.

  • You must have the dqs_administrator role on the DQS_MAIN database to terminate any running activities or stop any running processes in DQS.

Backup and Restore DQS Databases

  1. Start Microsoft SQL Server Management Studio, and connect to the appropriate SQL Server instance.

  2. In Object Explorer, expand the Databases node.

  3. Back up the DQS_STAGING_DATA database. For step-by-step instructions for backing a SQL Server database, see Create a Full Database Backup (SQL Server).

  4. Back up the DQS_PROJECTS database.

  5. Back up the DQS_MAIN database.

  6. Disconnect from the current instance of SQL Server, and connect to the SQL Server instance where you want to restore these databases.

  7. Restore DQS_MAIN database. For step-by-step instructions to restore a SQL Server database, see Restore a Database Backup Using SSMS.

  8. Restore the DQS_PROJECTS database.

  9. Restore the DQS_STAGING_DATA database.

  10. In Object Explorer, right-click the server, and then click New Query.

  11. In the Query Editor window, copy the following SQL statements, and replace <PASSWORD> with the password that you provided during the DQS installation for the database master key:

    USE [DQS_MAIN]  
GO  
EXECUTE [internal_core].[RestoreDQDatabases] '<PASSWORD>'  
GO

  12. Press F5 to execute the statements. Check the Results pane to verify that the statements have executed successfully.

See Also

Manage DQS Databases