SQL Server X64 log shipping, bulk logged, index rebuild.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 06 Mar 2008 16:42 GMT

Hello,
SQL Server 2005 X64 sp2+
We need to minimize tran log growth during index rebuilds because the
database is logged shipped. I know log shipping supports bulk logged
recovery model and that index rebuild are minuimally logged in bulk logged
model.
My question is as follows. If a database is in full recovery mode can it be
switched to bulk logged , indexes rebuilt, then switched back to full mode
without breaking the log shipping paradigm?
Any one with any MS documentation on this? or experience doing this?

TIA,

Reply to this Message

Kevin3NF - 06 Mar 2008 16:49 GMT

I ran this test for a customer and it works. But I didn't rebuild indexes
in the middle...he does.

Test it first....should take about 30 minutes. 1 table, one index, 5
minutes to GUI up the log ship.

Signature

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.

> Hello,
> SQL Server 2005 X64 sp2+
[quoted text clipped - 9 lines]
>
> TIA,

Reply to this Message