I am interested in seeing how you implemented. Thanks.

The discussions lead me to conclude that turn the db to bulk logged before rebuilding indexes on large db and put it back to full recovery is good practice if...

The missing transaction might be covered by the bug that I listed in my earlier post. Read that and let me know if your current version fits that scenario.

Yes....

David, Yes I meant out of sync (missing transaction). Also Tlog was bloated and continued to grow until I broke the replication or ran repldone.

I wonder if you could...

No. The very large db was not engaged in mirroring at all.

The issues (bloated tlog) I used to experienced were on sql2005 sp1 and sql2008 rtm.

I used structured dynamic codes something like 'use dbname; alter index .. rebuild online'

Thank you...

Gail, thanks. Your explanation why tlog bloated makes sense.

Gail, I understand that. These logged activities you mentioned (of course ) will not replicated to subscriber since SIMPLY they are not publication. And they have nothing to do with...

Thanks alot.

Interesting and hard to believe. I used to experience the out of sync alot after building indexes for a large table. TLog bloated due to the pending replication.

Gail:

Are you sure? rebuild index(such as alter index .. rebuild) is fully logged if db is full recovery db. As a result, log reader should scan log and replicated to...

If the database is simple/or bulk logged database, will the minimally logged activities such as rebuild indexes be replicated to subscribers?

Not sure why you concern it that much.

I do not think you REALLY can Simultaneously run them. So of course the results were different.

BTW, sql server 2008 r2 supports datafile/logfile on network share.

I had bad experience to delete backup files using the extended sproc. Seemed that this sproc can only delete the backup files sql created. It can not delete backup files...

I misunderstood "change the name". I think technically you can break the mirroring, drop the endpoint, recreate the endpoint with different name, then reestablish the mirroring. I could not tell...