Dropping full-text

• Paul Brown-333746

  Newbie

  Points: 3

  More actions

  May 31, 2006 at 7:24 am

  #113207

  Good day to you all

  I have inherited a database with lots of unnecessary full text indexing which I am trying to delete. When I attempt to remove an index I get this error:

  Error 20565: [SQL-DMO]Database is not full-text enabled yet.

  My first attempt to resolve this was issuing sp_fulltext_database 'enable'. After 3 hours the server ran out of disk space and the process bombed out. The log file had grown from a few mb's to 47gb (this is on a 25gb mdf file). I've cleared some space and have about 10gb free. I'm not worried about the log size as that can easily be shrunk but how do I remove these pesky full text catalogs without enabling full text indexing on the database?

  This is SQL2K by the way.

  Cheers

  Paul

• Prakash Sawant

  SSCrazy

  Points: 2173

  More actions

  May 31, 2006 at 10:32 am

  #640997

  Try seting recovery model to simple in db properties under options tab.

   

   

  ------------
  Prakash Sawant

  http://psawant.blogspot.com