Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mgole
Starting Member
9 Posts |
 Posted - 2005-03-14 : 18:57:44
|
| HiFor the restore jobs in log shipping,i have added 2 more steps,These are1.put DB in single user mode2.restore logs3.put DB in multi user modeWhen 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.?ThanksMadhukar |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-14 : 19:22:50
|
| Why have you done this? You don't need to do this for log shipping to work. In the log shipping setup, you should have selected the option to kick users out of the database before the restore is happening. Due to this, you don't need to add these steps to your jobs.Tara |
 |
|
|
mgole
Starting Member
9 Posts |
Posted - 2005-03-14 : 21:13:40
|
| I am using my standby server to run reports.So i need to add the additional steps.Also i had the teraminate users checkbox enabled..but still when i used to open query analyser..(i.e one more connection) my restore job used to fail.Madhukar |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-15 : 11:57:20
|
| Using the standby server to run reports is not a good idea as the user will lose its connection each time the restore job occurs. For long running reports, this is not good. To see what is occurring with your jobs, run SQL Profiler. You won't see everything as sqlmaint.exe does go outside of SQL Server to perform some tasks though.Tara |
|
|
|
|
|
|
log shipping jobs