Is there any way to pause Log shipping?

[SQLWilts]

Hi,
I am shipping logs from one SQL server 2000 to another using the wizard setup in Enterprise Edition. Unfortunately, the secondary server is on a slow link. Not a problem during the day normally, but weekly I do a rebuild of the indexes, which blows the transaction log big time - the log shipping then typically times out.
I was thinking about pausing log shipping, changing the recover mode of the DB to bulk-logged or simple, doing my DBCC command, changing the recovery mode back to full (we need point-in-time recovery) and kicking off the jobs/whatever again. Is this possible, or will it throw the logs out of sync and again break the log shipping?
Thanks in advance - and a Merry Christmas one and all

 

[ptheriault]

Yes, stop the log shipping copy and/or restore jobs on the target server.

- Paul
- Database performance looks fine, it must be the Network!

 

[ptheriault]

I should add don't change the recovery model to bulk logged. Just stop log shipping for the time of your re-indexing then start it up again. The first log will be large but I will get caught up after that.

- Paul
- Database performance looks fine, it must be the Network!

 

[sendba]

I have the same situation.I have to defrag a table daily.
My suggestion is disable the copy/restore job on the secondary server.
Once the index defrag is over then start the job.
It will take more time for the first log to be backed up and restored.

Sen

 

[SQLWilts]

I have disabled the restore, but left the copy running - this seems to work fine. Thanks for all the comments peeps