SQL Server Performance Forum – Threads Archive

log shipping restore job

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

Take help from thishttp://www.sql-server-performance.com/q&a37.asp article by Brad to accomplish the task. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>