Re: can't move file for full-text index

Hilary,

It still doesn't work. By the way I am using 2000 not 2005, does it make any
difference? For example the command SELECT name FROM SYS.DATABASE_FILES
WHERE TYPE_DESC='FULLTEXT'
does't work. But I am sure I have the right logical name for my index.

I've managed to physically move the files as in step 4 but when the issue
the alter database command I still get the same error message. It doesn't
also like it when the database is offline, gives me an error.

Any other ideas? Thanks.

Panos.



"Hilary Cotter" wrote:

Yes, it should be the logical name. Here is an example of how to do it.

1) determine the logical name of your full-text catalog file. Issue
the following command:
SELECT name FROM SYS.DATABASE_FILES WHERE TYPE_DESC='FULLTEXT'
Note the value returned in the name column. This is your logical name for
your full-text catalog. It will look something like this:
sysft_MyCatalogName where MyCatalogName is the name of your catalog.

2) Issue the below command:
ALTER DATABASE database_name SET OFFLINE

3) Stop Full-Text Search

4) Move the full-text catalog to the new location

5) Restart Full-Text Search

6) Issue the below command:
ALTER DATABASE database_name MODIFY FILE ( NAME = logical_name , FILENAME =
'new_path')
Where new_path is the new path to where you have moved your catalog.

7) Issue the below command:
ALTER DATABASE database_name SET ONLINE

You are now ready to query your full-text catalogs again.


--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Panos Stavroulis." <PanosStavroulis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:CAB627A0-C3AE-44B7-B12F-F1D98643E6F6@xxxxxxxxxxxxxxxx
Hi,

I need to move the file for my full-text catalog to a different drive due
to
space issues. I've tried the following:

ALTER DATABASE mailarchivedec05
MODIFY FILE (NAME = MailArchiver3, filename = 'F:\FTDATA')

But get an error:
Server: Msg 5037, Level 16, State 1, Line 1
MODIFY FILE failed. Do not specify physical name.

According to the posting below I should take the database first offline,
but
that gives a different error message about the db being offline.

http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?query=full-text+alter&dg=&cat=en-us-technet-sqlserv&lang=en&cr=US&pt=261BA873-F3AB-420E-96D6-E3004596A551&catlist=328BAFD2-1A81-4558-B1DE-B6EB49F31B7E&dglist=&ptlist=&exp=&sloc=en-us

Any other ideas? Thanks.

Panos.



.

Relevant Pages

  • Re: cant move file for full-text index
    ... For example the command SELECT name FROM SYS.DATABASE_FILES ... the alter database command I still get the same error message. ... "Hilary Cotter" wrote: ... determine the logical name of your full-text catalog file. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: cant move file for full-text index
    ... "Hilary Cotter" wrote: ... For example the command SELECT name FROM SYS.DATABASE_FILES ... the alter database command I still get the same error message. ... determine the logical name of your full-text catalog file. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Help..mssecure.cab not updating!
    ... verify that your synctask is INFACT running without any issues? ... catalog, you should remove the unattend switch from the sync cmdline. ... > have the synch utility to download the catalog on a weekly basis. ... > Command line specified package to update on DPs as XYZ00010 ...
    (microsoft.public.sms.admin)
  • Re: Image Catalogs & V5R4M5
    ... So, you want to upgrade your operating system to V5R4, or you just have ... create an image catalog with the command: ... Insert the first CD and enter the following command: ... to create a list of product to install, it will ask you the source type ...
    (comp.sys.ibm.as400.misc)
  • Re: Image Catalogs & V5R4M5
    ... So, you want to upgrade your operating system to V5R4, or you just have ... create an image catalog with the command: ... Insert the first CD and enter the following command: ... to create a list of product to install, it will ask you the source type ...
    (comp.sys.ibm.as400.misc)