Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Moving Full Text Catalog Expand / Collapse
Author
Message
Posted Tuesday, November 13, 2012 2:35 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, November 10, 2014 7:56 AM
Points: 598, Visits: 1,650
Hi all

I am wanting to move a Full Text Catalog in SQL 2008. As this is a logical file in the DB, and I would normally just detach and re-attach the db files, how can I do this now?

Is the only way to do a backup and restore and move it at the time? Also are there any other considerations I need to take into account in regards the Full text Catalog?

Thanks
Post #1383987
Posted Tuesday, November 13, 2012 4:12 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, November 20, 2014 3:50 AM
Points: 709, Visits: 1,441
Moving Database Files

Backing Up and Restoring a SQL Server 2008 Full-Text Catalog


Joie Andrew
"Since 1982"
Post #1384022
Posted Tuesday, November 13, 2012 6:21 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, November 10, 2014 7:56 AM
Points: 598, Visits: 1,650
OK thanks
Post #1384051
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse