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 Quality Server to another server. You have a
recent backup of all the required databases.
What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)
A.
Restore the DQS_MAIN, DQS_PROJECTS, and DQS_STAGING_DATA databases to
another server as soon as possible.
B.
Execute the DQS_MAIN.internal_core.RestoreDQDatabases stored procedure with the
appropriate parameter.
C.
Restore only the DQS_MAIN and DQS_STAGING_DATA databases to another server as
soon as possible.
D.
Execute the DQS_MAIN.internal_core.InitServer stored procedure with the appropriate
parameter.
Explanation:
Steps to restore DQS Databases:
1. Restore DQS_MAIN database.
2. Restore the DQS_PROJECTS database.
3. Restore the DQS_STAGING_DATA database.
4. In Object Explorer, right-click the server, and then click New Query.
5. 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
6. Press F5 to execute the statements. Check the Results pane to verify that the
statements have executed successfully.
Note:
* 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.
A,B
Yes. A, B
A + B
https://msdn.microsoft.com/en-us/library/hh213068(v=sql.110).aspx