• YarHad (10/9/2012)


    ...I am rebuilding/reorganizing indexes and I am trying to locate the activity via server logs...

    If you're reorganizing or rebuilding your indexes in a SQL Agent Job, you can examine the Job History for that job to see the details about the job: execution start time, time to execute, success or failure, and more.

    The rebuild operation can be minimally logged to the database log file if the database recovery model is set to either bulk-logged or simple.