Link to home
Create AccountLog in
Avatar of realcoding
realcodingFlag for United States of America

asked on

move physical location of FTS catalog on prod sql2005

I'm looking at a SQL Server 2005 database that has the mdb and logs on the E drive, but for some reason has the full text catalog on the C drive.

How do I move it to the E drive?

Also note this is a production single stand-alone server... will the solution need downtime, a reboot?

thanks all!
Avatar of sammySeltzer
sammySeltzer
Flag of United States of America image

Use a two-step process.

1, detach the database first.
Use Master
GO

-- Set database to single user mode
ALTER DATABASE yourDB
SET SINGLE_USER
GO

-- Detach the database
sp_detach_db 'YourDB'
GO

Step 2: Now copy from current location to another location:

USE master
GO

-- Now Attach the database
sp_attach_DB 'YourDB',
'D:\Program Files\Microsoft SQL Server\MSSQL\Data\YourDB_Data.mdf', --old location
'E:\Move LogFile here through T-SQL\YourDB_Log.ldf'
GO


Try
Avatar of realcoding

ASKER

@sammySeltzer:

the mdf and lddf files are int he correct location on the E drive.

the database also has a full text search catalog that is located on the C drive.

i need to move only the FTS catalog from the C drive to the E drive.

also note, i would prefer a solution where i dont have to take the DB down as this is a production system
ASKER CERTIFIED SOLUTION
Avatar of sammySeltzer
sammySeltzer
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
I also found this Microsoft KB about relocating your fts catalog same time you are relocating your database.

Have a read:

http://support.microsoft.com/kb/910067