You are the administrator of a server that hosts Data Quality Server for a large retail company. The server had a hardware failure during business hours. You need to restore the server that hosts Data

Question

Options

• ARestore the DQS_MAIN, DQS_PROJECTS, and DQS_STAGING_DATA databases to
• BExecute the DQS_MAIN.internal_core.RestoreDQDatabases stored procedure with the
• CRestore only the DQS_MAIN and DQS_STAGING_DATA databases to another server as
• DExecute the DQS_MAIN.internal_core.InitServer stored procedure with the appropriate

• A
  84% (43)
• C
  4% (2)
• D
  12% (6)

Explanation

Steps to restore DQS Databases: - Restore DQS_MAIN database. - Restore the DQS_PROJECTS database. - Restore the DQS_STAGING_DATA database. - In Object Explorer, right-click the server, and then click New Query. - 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: EXECUTE [internal_core].[RestoreDQDatabases] '<PASSWORD>' - Press F5 to execute the statements. Check the Results pane to verify that the statements have executed successfully. - Backup and restore of SQL Server databases are common operations that database administrators perform for preventing loss of data in a case of disaster by recovering data from the backup databases. Data Quality Server is primarily implemented by two SQL Server databases: DQS_MAIN and DQS_PROJECTS. The backup and restore procedures of the Data Quality Services (DQS) databases are similar to any other SQL Server databases.

No community discussion yet for this question.