moving DBs with Full text search enabled

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

moving DBs with Full text search enabled

Author

Topic

jpotucek
Constraint Violating Yak Guru

273 Posts

Posted - 2008-03-24 : 05:55:33

SQL Server 2005 sp2 Standard Edition.

I have a bunch of databases to relocated. relocating them on the same server - I just want to split the data and log files onto their own Volumes. these DBs have Full Text Indexing enabled.
This Server is a brand new build and NOT in production yet

How is the best way to move these Dbs and how do locate and move the full text catalog for each?? or do I even have to worry about that?? Is back-restore (with move) better for this?

When I look in BOL.. here is the syntax for an attach

USE master;
GO
--Detach the AdventureWorks database
sp_detach_db AdventureWorks;
GO
-- Physically move the full text catalog to the new location.
--Attach the AdventureWorks database and specify the new location of the full-text catalog.
CREATE DATABASE AdventureWorks ON 
    (FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf'), 
    (FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_log.ldf'),
    (FILENAME = 'c:\myFTCatalogs\AdvWksFtCat')
FOR ATTACH;
GO

Do I have to move the Full text Catalog? If so, how do I find it's current location. If I do have to move it, where is the best place to locate the catalogs???

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-24 : 23:12:55

If you move dbs between sql2k5 servers, backup/restore will handle full text index.

jpotucek
Constraint Violating Yak Guru

273 Posts

Posted - 2008-03-27 : 09:46:14

Thank you!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources