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!
realcodingAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sammySeltzerCommented:
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
realcodingAuthor Commented:
@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
sammySeltzerCommented:
My bad, sorry.

Here is a link that has instructions on how to do that.

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

Go down to the section titled: To move or copy full-text catalogs between local drives or paths on the same computer that is running SQL Server

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sammySeltzerCommented:
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

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.