restoring database with FTS to another machine

Hi,
I would like to help me to restore the FTS database in another machine. The
problem is that in the main server the drive letter is different than in the
one where I want to restore, in the production(main) server drive in M, in
the test server I can put it in D, for instance. Can you please tell me the
best or easiest way of restoring this database?
Thanks a lot,
BaniSQL
I tried this to change the path in another server where I restored my db:
DECLARE @.path_s VARCHAR(100)
SELECT @.path_s = 'D:\Fulltext' -- CHANGE HERE IF WANTED
IF @.path_s = ''
BEGIN
SELECT @.path_s = LEFT(filename, LEN(RTRIM(filename)) - CHARINDEX('\',
REVERSE(RTRIM(filename))))
FROM sysfiles WHERE fileid = 1
END
UPDATE dbo.sysfulltextcatalogs SET path = @.path_s
GO
Any other solution from your side ?
Thanks,
BaniSQL
"BaniSQL" wrote:

> Hi,
> I would like to help me to restore the FTS database in another machine. The
> problem is that in the main server the drive letter is different than in the
> one where I want to restore, in the production(main) server drive in M, in
> the test server I can put it in D, for instance. Can you please tell me the
> best or easiest way of restoring this database?
> Thanks a lot,
> BaniSQL