PrepAway - Latest Free Exam Questions & Answers

What should you do first?

You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 contains two user databases. SQL1 also contains the publisher database for a transactional replication publication. Every night, a full backup is made of all databases. Transaction log backups are made twice each day for both user databases. SQL1 is configured to use SQL Server and Windows authentication. Client applications connect by using SQL Server login accounts. The disk subsystem on SQL1 experiences a complete failure. You replace the failed hardware, reinstall Microsoft Windows Server 2003, and reinstall SQL Server 2005. You need to ensure that SQL1 is operating normally as quickly as possible and with a minimum loss of data. Your solution must make the user databases available to client applications as soon as those databases are restored. What should you do first?

PrepAway - Latest Free Exam Questions & Answers

A.
Restore all of the system databases.

B.
Restore the two user databases only.

C.
Restore the publisher database only.

D.
Re-create the transactional replication publication.

Explanation:
If you choose to perform any of the other options you miss all login information used to connect to any of the databases.


Leave a Reply