move full-text-search catalog
I'm have a SQL Server 2005 database that has the data and开发者_StackOverflow logs on their own drives and have created a full text search for the first time and looks like i missed the part where i needed to spec the location the catalog was saved to and wound up having it on my c drive.
my c drive is for OS only.
how can i move the catalog to another location on the same machine?
For SQL Server 2005, follow this procedure:
To move a data or log file as part of a planned relocation, follow these steps:
Run the following statement.
ALTER DATABASE database_name SET OFFLINE
Move the file or files to the new location.
For each file moved, run the following statement.
ALTER DATABASE database_name MODIFY FILE ( NAME = logical_name, FILENAME = 'new_path\os_file_name' )
Run the following statement.
ALTER DATABASE database_name SET ONLINE
Verify the file change by running the following query.
SELECT name, physical_name AS CurrentLocation, state_desc FROM sys.master_files WHERE database_id = DB_ID(N'<database_name>');
精彩评论