all groups > sql server replication > june 2004 >
You're in the

sql server replication

group:

log shipping question



log shipping question biju george
6/13/2004 11:58:34 PM
sql server replication: 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
Re: log shipping question Paul Ibison
6/14/2004 8:52:00 AM
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

AddThis Social Bookmark Button