• I suggest two more things before starting any of that.

    1. Backup the database

    2. Disable access to the server for all connections not related to you, the team, or whomever is working on the project for the duration of the project.

    And then of course, make sure to do it during a maintenance window.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events