Home » Microsoft » 70-458 » What should you do?
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.
Correct Answer: AB
Explanation/Reference:
Explanation:
AB
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:
USE [DQS_MAIN]
GO
EXECUTE [internal_core].[RestoreDQDatabases] ‘<PASSWORD>’
GO
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.