can't move file for full-text index

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.
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@.discussions.microsoft.com> wrote in
message news:CAB627A0-C3AE-44B7-B12F-F1D98643E6F6@.microsoft.com...
> 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.
|||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@.discussions.microsoft.com> wrote in
> message news:CAB627A0-C3AE-44B7-B12F-F1D98643E6F6@.microsoft.com...
>
>
|||I did not realize you were using SQL 2000. In this case follow these steps:
http://support.microsoft.com/kb/240867
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@.discussions.microsoft.com> wrote in
message news:153D7F5D-76C4-45D2-835B-B0AB382DDD7B@.microsoft.com...[vbcol=seagreen]
> 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:
|||That worked fine. Thanks.
"Hilary Cotter" wrote:

> I did not realize you were using SQL 2000. In this case follow these steps:
> http://support.microsoft.com/kb/240867
> --
> 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@.discussions.microsoft.com> wrote in
> message news:153D7F5D-76C4-45D2-835B-B0AB382DDD7B@.microsoft.com...
>
>

Can't locate RS 2005 in MSDN library

I'm having trouble locating the RS 2005 install in the MSDN subscription
catalog. Can anyone tell me on which CD/DVD the install in located. I have
the SQL Server DVD. I can't seem to locate it when I search the online
subscription list either.
Thanks.If I put the unfiltered by as unfiltered and then look for reporting
services I find it.
Have you installed SQL Server Books On Line for SQL Server 2005? If you
don't see it in MSDN Library you will find it in Books On line SQL Server
2005
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JW" <JW@.discussions.microsoft.com> wrote in message
news:9DF6DFF8-246B-4E82-9442-18F0F4E59D40@.microsoft.com...
> I'm having trouble locating the RS 2005 install in the MSDN subscription
> catalog. Can anyone tell me on which CD/DVD the install in located. I
> have
> the SQL Server DVD. I can't seem to locate it when I search the online
> subscription list either.
> Thanks.|||Sorry for the confusion. I'm looking for the install DVD in my MSDN
subscription. I was of the understanding that reporting services 2005 would
be in my December shipment but can't locate it. I also can't find it when I
search the subscription index here:
http://msdn.microsoft.com/subscriptions/index/default.aspx or in my online
subscription download.
"Bruce L-C [MVP]" wrote:
> If I put the unfiltered by as unfiltered and then look for reporting
> services I find it.
> Have you installed SQL Server Books On Line for SQL Server 2005? If you
> don't see it in MSDN Library you will find it in Books On line SQL Server
> 2005
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "JW" <JW@.discussions.microsoft.com> wrote in message
> news:9DF6DFF8-246B-4E82-9442-18F0F4E59D40@.microsoft.com...
> > I'm having trouble locating the RS 2005 install in the MSDN subscription
> > catalog. Can anyone tell me on which CD/DVD the install in located. I
> > have
> > the SQL Server DVD. I can't seem to locate it when I search the online
> > subscription list either.
> >
> > Thanks.
>
>|||RS does not have a separate DVD/CD. It is part of the SQL Server 2005
install. The only reason it did initially was that it was release mid cycle
for SQL Server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JW" <JW@.discussions.microsoft.com> wrote in message
news:B68EAD4B-993D-47AB-9721-DABC2A0ACCD0@.microsoft.com...
> Sorry for the confusion. I'm looking for the install DVD in my MSDN
> subscription. I was of the understanding that reporting services 2005
> would
> be in my December shipment but can't locate it. I also can't find it when
> I
> search the subscription index here:
> http://msdn.microsoft.com/subscriptions/index/default.aspx or in my online
> subscription download.
> "Bruce L-C [MVP]" wrote:
>> If I put the unfiltered by as unfiltered and then look for reporting
>> services I find it.
>> Have you installed SQL Server Books On Line for SQL Server 2005? If you
>> don't see it in MSDN Library you will find it in Books On line SQL Server
>> 2005
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "JW" <JW@.discussions.microsoft.com> wrote in message
>> news:9DF6DFF8-246B-4E82-9442-18F0F4E59D40@.microsoft.com...
>> > I'm having trouble locating the RS 2005 install in the MSDN
>> > subscription
>> > catalog. Can anyone tell me on which CD/DVD the install in located. I
>> > have
>> > the SQL Server DVD. I can't seem to locate it when I search the online
>> > subscription list either.
>> >
>> > Thanks.
>>