Activity overview
Latest activity by geoff.tanner
Peter, thanks for this post, I applied the MAXTRANSFERSIZE setting to the restore jobs and they are all succeeding now. I appreciated your rapid response and accurate answers. / comments
Peter, thanks for this post, I applied the MAXTRANSFERSIZE setting to the restore jobs and they are all succeeding now. I appreciated your rapid response and accurate answers.
Pete, thanks for the post. CPU gets to about 58% for about 5 seconds during the log restore. The databases are all fairly small - not many transactions - so the entire 23 DBs take about the 5 to 10 seconds to restore. On the job step theme, I could do that. I am a bit disappointed to have to take that step though, as the whole idea for me was to let SQL Backup manage the required jobs and schedules. Do people not usually ship logs for so many databases? / comments
Pete, thanks for the post. CPU gets to about 58% for about 5 seconds during the log restore. The databases are all fairly small - not many transactions - so the entire 23 DBs take about the 5 to 10...
Timing of Log Shipping Transaction Log Restores
I have about 33 databases that I want to log ship. Seems like a lot, but they are required. I have set up 23 of the jobs on a 15 minute interval. On the whole the process works but I am starting t...
Thanks, Peter, I will use that technique in the future / comments
Thanks, Peter, I will use that technique in the future
Stop and re-start Log Shipping
This may seem like a dumb question but I did not see anything in the forum - how does one stop and re-establish a log shipping job in SQL Backup? The obvious way seems to be to delete both jobs and...