Home Forums SQL Server 7,2000 Administration Need to Defrag Indexes Without Writing to the Transaction Log RE: Need to Defrag Indexes Without Writing to the Transaction Log

  • You can't prevent this from writing to the transaction log, but you could preform tlog backups more frequently during this process to keep the size to a minimum.



    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]