Shafat Husain (12/26/2014)
Another way to go about it is that you can change the recovery model of the database from Full to Bulk logged and hence Alter Index statement would be minimally logged.
Not if the database is mirrored. Mirroring requires full recovery. It also won't help with log shipping. Bulk logged can reduce the amount written into the transaction log, but the log backups will be the same size, if not larger, and it's the size (and copy time) for the log backup files which are the problem in this case.
p.s. 4 year old thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability