Home Forums SQL Server 2005 Administering indexing online vs offline, and setting a database offline RE: indexing online vs offline, and setting a database offline

  • Jeff Moden (1/19/2010)


    And just so you know, rebuilding indexes using the "Online" option is only an option in the Enterprise and Developer's (Enterprise with very limited licensing) Editions.

    ..... and in order to be bale to do the online indexing, the tables cannot contain: XML index, Spatial index, Large object data type columns (image, text, ntext, varchar(max), nvarchar(max), varbinary(max), and xml) in which case you need to do an offline reindexing (which does not mean taking the database off-line...)

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]