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?
 
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
 
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
 
nova24Author Commented:
Used the ALTER DATABASE commands.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.