backup 20x larger than database file

  • Does FULLTEXT=0 means it is not enabled ?

    What has to done ? Can I drop it an recread ?

  • vrsdesign (6/29/2012)


    Does FULLTEXT=0 means it is not enabled ?

    What has to done ? Can I drop it an recread ?

    That was a result with the file size internal to sql server. Fulltext is stored externally. Thus a 0 is expected. It does not mean that fulltext is disabled. And you know that you have 120GB in fulltext indexes. You need to discuss with your employer if they need fulltext or not. We can't answer that for you.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Thank you very much for your help.

Viewing 3 posts - 16 through 17 (of 17 total)

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