How do i move the FTData folder under SQL 2005 to a different drive

Currently my FTData folder is on the C drive in its default location and is filling up my drive. I need to move this folder to a different drive. What is the best way to do this under SQL Server 2005?
FYI, this is a standalone SQL server.

Thanks,
Dennis
nova24Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

mdagisCommented:
Open Enterprise manager and on right click properties on server there is an option to set the default datafiles path
0
nova24Author Commented:
That looks like it's for the DB's and Log files only, not the FTData folder.
0
ProjectChampionCommented:
***********************************************************************
IMPORTANT NOTE: TAKE A FULL BACK UP OF YOUR DB BEFORE FOOLWING THESE STEPS!!!!
***********************************************************************
To move a full-text catalog, use the following steps. Note that when you specify the new catalog location, only new_path is specified instead of new_path/os_file_name.

1.Run the following statement.

ALTER DATABASE database_name SET OFFLINE
2.Move the full-text catalog to the new location.

3.Run the following statement where logical_name is the value in the name column in sys.database_files and new_path is the new location of the catalog.

ALTER DATABASE database_name MODIFY FILE ( NAME = logical_name , FILENAME = 'new_path')
4.Run the following statement.

ALTER DATABASE database_name SET ONLINE
Alternatively, you can use the FOR ATTACH clause of the CREATE DATABASE statement to move a full-text catalog. The following example creates a full-text catalog in the AdventureWorks database. To move the full-text catalog to a new location, the AdventureWorks database is detached and the full-text catalog is physically moved to the new location. Then the database is attached specifying the new location of the full-text catalog.

USE AdventureWorks;
CREATE FULLTEXT CATALOG AdvWksFtCat AS DEFAULT;
GO
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\MSSQL10.MSSQLSERVER\MSSQL\Data\AdventureWorks_Data.mdf'),
    (FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data\AdventureWorks_log.ldf'),
    (FILENAME = 'c:\myFTCatalogs\AdvWksFtCat')
FOR ATTACH;
GO
0

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
nova24Author Commented:
Used the ALTER DATABASE commands.
0
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.