70-450 · Question #64
You are a professional level SQL Sever 2008 Database Administrator. Log shipping should be implemented for several databases on three SQL Server instances. The logs are migrated to a fourth SQL…
The correct answer is A. To achieve the goal, you should utilize the WITH RECOVERY option on the last log to apply B. To achieve the goal, you should redirect client computers to the secondary instance. D. To achieve the goal, you should utilize the WITH NORECOVERY option to back up the tail. Log shipping consists of three operations: 1. Back up the transaction log at the primary server instance. 2. Copy the transaction log file to the secondary server instance. 3. Restore the log backup on the secondary server instance. The log can be shipped to multiple secondary…
Question
You are a professional level SQL Sever 2008 Database Administrator. Log shipping should be implemented for several databases on three SQL Server instances. The logs are migrated to a fourth SQL Server instance. A manual failover will be implemented. You need to ensure that the database applications utilize the secondary server after failover. Since you are the technical support, you are required to confirm that the latest data should be available to users. Which actions should you perform to achieve the goal? (Choose more than one)
Options
- ATo achieve the goal, you should utilize the WITH RECOVERY option on the last log to apply
- BTo achieve the goal, you should redirect client computers to the secondary instance.
- CTo achieve the goal, you should replicate all log shipping network shares to the secondary
- DTo achieve the goal, you should utilize the WITH NORECOVERY option to back up the tail
- ETo achieve the goal, you should back up all databases on the secondary instance.
How the community answered
(27 responses)- A81% (22)
- C7% (2)
- E11% (3)
Explanation
Log shipping consists of three operations: 1. Back up the transaction log at the primary server instance. 2. Copy the transaction log file to the secondary server instance. 3. Restore the log backup on the secondary server instance. The log can be shipped to multiple secondary server instances. In such cases, operations 2 and 3 are duplicated for each secondary server instance. A log shipping configuration does not automatically fail over from the primary server to the secondary sewer. It the primary database becomes unavailable, any of the secondary databases can be brought online manually. To make the target as the new source database you have to 1. Backup the transaction log tail in order to have the latest transactions and to put the database in recovery state BACKUP LOG lzldventuxewoxks] PTOgTam lileS\Mic:T »;s0fl; SQL TO DISK = N ' C : \ Server\MSSQL10 .MSSQLSERVER\MSSQL\Backup\Adv.trn` WITH NO_TRUNCATE , NAME = N' Adva.ntu:l:s,.W0Tks--Tra11Saction Log Backup ' , 2. After having copied all the transaction log backup, restore them in order and, tor the latest, use the WITH RECOVERY option 3. Redirect all the clients to the new source database.
Topics
Community Discussion
No community discussion yet for this question.