SQL Server Performance

log shipping restore job

Discussion in 'SQL Server Log Shipping' started by mgole, Mar 14, 2005.

  1. mgole New Member

    Hi

    For the restore jobs in log shipping,i have added 2 more steps,These are

    1.put DB in single user mode
    2.restore logs
    3.put DB in multi user mode

    When i check the job history,it shows me the duration of each of these steps together with the total time taken(which is mentioned as Job Outcome).

    But the Job Outcome Duration is not equal to the sum of all the three steps.What is this additional time which it shows.?

    Thanks

    Madhukar
  2. satya Moderator

Share This Page