March 24, 2008 at 3:53 am
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???
March 24, 2008 at 7:34 am
Full text catalogs are backup up when you perform a full database backup. When restoring the database, the FTC should be pointing to the same place. If you want to move the catalogs, you can do so with an attach/detach with move.
To get the location of your FTC use this:
select *
from sys.fulltext_catalogs
more info:
March 24, 2008 at 8:13 am
Thanks!
select *
from sys.fulltext_catalogs
returns NO results. Does that mean that the catalogs have not been built yet because there is no data in the tables? Can I safely move the databases without touching the catalogs?
March 24, 2008 at 10:16 am
Well no results usually means that you have any FTCs. Can you confirm that the text catalogs are in the questioned database. If you used the attach/detach method, you should have moved the FTC with the database files.
If you restored the database, the FTC comes with it in the original location, provided the new database has the appropriate rights to get to the directory.
There is information about how to restore the FTC after the fact, in the link I posted above. The syntax should look something like this.
RESTORE DATABASE AdventureWorks
FILE = 'sysft_fulltext_cat'
FROM backup_device
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply