InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Are The Uses Of Standby Mode In Log Shipping? |
|
Answer» If the Restore JOBS is scheduled / delayed for longer intervals this option can be used. As uses needs to be disconnected every time Restore JOB runs(to ENSURE timely shipping of Transaction Logs) its recommended not to use this option for regular, less interval Log Shipping configurations. Using this option gives us advantage of Load BALANCING for READONLY connections and Reporting purposes at the cost of timely disconnections to HELP success of Restore Jobs. If the Restore Jobs is scheduled / delayed for longer intervals this option can be used. As uses needs to be disconnected every time Restore Job runs(to ensure timely shipping of Transaction Logs) its recommended not to use this option for regular, less interval Log Shipping configurations. Using this option gives us advantage of Load Balancing for READONLY connections and Reporting purposes at the cost of timely disconnections to help success of Restore Jobs. |
|