April 1, 2010 at 6:45 am
I am currently setting up Log shipping on 4 our produciton databases. As 3 of these databases are not highly transactional we take transaction logs once a day. I just wanted to know the best scenario for the copy/load frequency. Should I also schedule it for once a day
April 1, 2010 at 6:52 am
eseosaoregie (4/1/2010)
I am currently setting up Log shipping on 4 our produciton databases. As 3 of these databases are not highly transactional we take transaction logs once a day. I just wanted to know the best scenario for the copy/load frequency. Should I also schedule it for once a day
Even if u schedule it to run for more than once a day, actual copy restore will happen once only. I think u shud schedule the copy job after ur tran log job finishes (with some buffer time) and ur restore job at a time later than copy job (copy job timestamp+appx time to copy the file + little buffer)
April 1, 2010 at 7:00 am
OK, makes sense. thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply