Post reply

SQL 2008 FTS Catalogs on Dedicated Disk Array

  • January 8, 2012 at 7:33 am

    #248614

    Please tell me the steps I must follow to locate Full Text Search Catalogs/Indexes on a separate disk array from the database.

  • January 9, 2012 at 4:35 am

    #1430370

    If SQL 2008 and above, the FTS catalogs are part of the database.

    If you want to store the tables with FTS indexes and the associated FTS catalog of a separate disk array from the rest of the database, then create a new Filegroup that has a file on your disk array. After you have done this, do ALTER TABLE statements to move the affected tables and indexs to the new filegroup.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply