Home Forums SQL Server 2005 Administering SQL Server Maintenance Solution SP doesn't seem to work as expected RE: SQL Server Maintenance Solution SP doesn't seem to work as expected

  • Default the parameter for high fragmentation is set like this:

    @FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE'

    This means that it will rebuild an index online if that is possible. If that is not possible, it will rebuild the index offline.

    Here it has been set like this:

    @FragmentationHigh = 'INDEX_REBUILD_ONLINE'

    This means that it will rebuild an index online if that is possible. If that is not possible, it will skip the index. As you have Standard Edition it will not be able to rebuild the index online and the index will therefore be skipped.

    So you need to change the parameter to allow for offline rebuilds or upgrade to Enterprise Edition.

    Ola Hallengren

    http://ola.hallengren.com