Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Rebuild Index vs Drop and Create Index RE: Rebuild Index vs Drop and Create Index

  • July 10, 2008 at 4:21 pm

    #841160

    shensarling (7/10/2008)

    Thanks for the reply Steve.

    We have decided to set the Recovery Model of the database to Bulk-logged and then drop and recreate the index. After creating the index we will set the Recovery Model back to Full. The bulk-logged recovery model minimally logs bulk operations, in my case the creation of an index.

    Make sure you take a full backup or at least a log backup "right after" you switch the recovery mode.


    * Noel