restoring database with FTS to another machine

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BaniSQL - 28 May 2007 10:27 GMT

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

Reply to this Message

BaniSQL - 29 May 2007 08:30 GMT

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

> Hi,
> I would like to help me to restore the FTS database in another machine. The
[quoted text clipped - 5 lines]
> Thanks a lot,
> BaniSQL

Reply to this Message