Friday, March 23, 2012

log shipping question

Hi Guys,
i am planning to implement logshipping on sql 2000 EE.
i have two questions on this.
i am planning to use log shipping interval of 2 minutes
1) can dump the transaction log backup on network share
instead of production server.
if yes will it have any other impact?
2) every month i am rebuilding my indexes which will
create a huge transaction log
will it create any problem on log shipping.
pls advice me
Biju
Biju,
1: network share is OK. Obviously if the sahre is unavailable then there'll
be a problem, so local folders are normally used.
2: make sure the load and copy frequency are both one minute and this should
prevent a backlog building up.
HTH,
Paul Ibison

No comments:

Post a Comment