Post reply

Backups for databases with Full Text Catalogs

  • September 4, 2007 at 6:40 am

    #118106

    Hello everyone,

      We run Microsoft's CRM which uses Full Text Catalog and we back the databases up with Redgate's SQLBackup. Is there something special that needs to be done to backup a database that uses Full Text Catalog? Is there something special for restoring these databases? I have never dealt with Full Text Catalogs before, so any help would be appreciated.

     

    Thanks!

      

     

  • September 4, 2007 at 6:41 am

    #731186

    BTW - this is running under SQL Server 2005.

  • September 5, 2007 at 6:45 am

    #731473

    After further research, I found that SQLServer 2005 backups include the full text catalog location and files. When restoring to a different location, you just add the full text catalog as you would any database files to the restore script.

  • September 5, 2007 at 9:47 pm

    #731683

    Have you tested it yet?  Another compression product, not Red Gate, had some real problems with a restore of a full-text index to another location last time we tried it - that was some time ago though...

    Joe

     

     

  • September 6, 2007 at 5:16 am

    #731764

    Yes, it was tested and worked just fine. No problems with the application after the restore and testing went fine. 

Viewing 5 posts - 1 through 4 (of 4 total)

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