July 19, 2006 at 7:37 am
Hi
Im trying to set up SQL replication between two sql 2005 boxes. Im a newbie so Im taking a tiny step forwsard, hitting a wall, Googling for half and hour and then progressing another miniscule amount.
however, I cant get past my latest error.
I have enabled full test replcation on the database that I want to replicate - I set the value to 'true' when I set up the snapshot. Then after an error and some googling, I ran
use <database>
go
exec sp_fulltext_database 'enable'
go
to apparently tell the replica server that I had infact turned on Full Text Searching on the master and to stop being a nobbo and to just get on with it.
Now im getting
"Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'dbo.arc_bodies' because it is not full-text indexed."
I have googled and found the following:
sp_changepublication @publication = 'yyy'
, @property = 'sync_method'
, @value = 'native'
, @force_invalidate_snapshot = 1
which I run with no success. I substitue 'yyy' for the name of the database AND the name of the publication on BOTH the Master and Replica servers but no matter what I do or where I run it, I get:
Msg 14013, Level 16, State 1, Procedure sp_MSrepl_changepublication, Line 94
This database is not enabled for publication.
when surely it is???? - publication is setup and the snapshot is created....
Can someone dig me out of my pit of frustration?
Thanks is advance
Alastair Jones
July 20, 2006 at 8:13 pm
I can only suggest going back to square one by removing the exsting publisher and subscriber setup - right click Replication node in Management Studio, select disalbe Publishing and distributing
Then, with what you now know as something you should have possibly setup before or as part of the setup - try it again.
Not conclusive by any means but may be a way for you to ensure things are not "tangled" as far as your server is concerned.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply