FTS configuration in another machine

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Database Design and Application Architecture

FTS configuration in another machine

Author

Topic

sqlzagi
Starting Member

11 Posts

Posted - 2007-05-28 : 15:23:39

Hi to all,
I'm having problem to enable FTS and re-configure FTS when I'm restoring the existing db with FTS in another machine.
In this database the FTS is running and FTS catalogs as well, the path for FTS of this database is in drive M.
When I'm restoring this database in another server I have problems to re-configure FTS, in this server there's no drive M, how can continue using FTS, please suggest!

Thnks a lot
SqlZagi

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-28 : 16:17:53

Try drop and recreate it.

sqlzagi
Starting Member

11 Posts

Posted - 2007-05-29 : 02:29:09

I couldn't remove, bacause of the path that was not existing in this another server.
I tried this:

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

-- NOW IN ENTERPRISE MANAGER PRESS THE RIGHT BUTTON ON FOLDER FULL-TEXT CATALOGUES AND CHOOSE REBUILD ALL CATALOGUES

But, it is taking too long, my server was blocked.
Any other solution?

Thnx,
SqlZagi

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-29 : 13:43:42

Is it sql2k or sql2k5? In sql2k5, you can use move option in 'restore database' statement to change FTS path.

sqlzagi
Starting Member

11 Posts

Posted - 2007-05-30 : 18:23:32

In SQL2K i tried that, in Sql5k not, because I couldn't have a chance to modify system catalogs, it's not allowed.
You mentioned moving with restore db I can change the FTS path in SQL5K, I would like to know this, can you please explain more about this?

Thnx,
SqlZagi

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-30 : 23:03:42

Same option as move db files during restore, you can find it in books online. In sql2k,FTS is not backed up when backup db.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources