| Author |
Topic |
|
mr_mist
Grunnio
1870 Posts |
 Posted - 2004-06-02 : 09:55:00
|
| HiIn the BOL for log shipping, it seems to suggest that I can only put in an interval between log ship backup/restores, and a delay interval.What I would like to do, is to have log shipping take backups during working hours, and then apply those backups after working hours.Is this possible? In which case how do I configure it?Is it acceptable to simply change the schedule on the destination server "Log Shipping Restore" job?-------Moo. :) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-02 : 12:48:51
|
| After you configure log shipping, you just need to modify the jobs. There will be one job on the source server for the transaction log backup and full backup. There will be two jobs on the destination server for copying of the tlogs and restoring them. So just change the job schedule on them.Tara |
 |
|
|
MuadDBA
628 Posts |
Posted - 2004-06-02 : 15:55:43
|
| If it were me, I'd just change the job schedule for APPLYING the logs, not for copying them. Otherwise a problem on your production server whacks all the files you might need to get teh standby server up and running again. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-02 : 15:58:38
|
| I agree. The copy jobs would have a lot of work to do if you waited. Why though would you want to apply them after hours though? Isn't this on a standby server that no one is using?Tara |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-06-03 : 03:08:51
|
| The reason for applying out of hours is that the business wants to use the shipped server as a reporting database during the working week (so it serves that purpose as well as DR).-------Moo. :) |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-03 : 08:08:22
|
| That's a big DR window isn't it? How long does it take to apply all those logs? Have you thought about two instances?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-06-03 : 08:12:12
|
| It will still have to be investigated for timing issues, the main problem being that we do not have a full load or backup from which to test. In theory though, it can take all night to apply the backups if it has to.I'm not sure how having two instances would help out in this scenerio?-------Moo. :) |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-03 : 08:15:36
|
| If you have the disk space but no extra server, you can have your default instance restoring the log backups. The "other" instance can just house reporting. At the end of the night after your full backup stop the default instance, copy the files to the directory housing data and log files for the other instance, attach dbs, then turn on the default instance.You would then have two copies; and you're probably looking at a minimum time window to do this in. You run DR off the default, which is kept up-to-date throughout the day. You run reporting off the other instance.Better yet, buy a second server. lolMeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-06-03 : 08:22:33
|
| Hmm, disk space I think may be an issue but I might mention this possibility.-------Moo. :) |
|
|
|
|
Log Ship at specified times