July 11, 2002 at 12:07 pm
After setting up 2 SQL 2000 Servers, is it possible to restore a backup on one, then configure it as a Publisher/Distributor, take a snapshot and then replicate the restored DB to the subscriber? If so, what steps are required to accomplish this?
I've tried to restore the backup to both servers, but when I initiate the Merge Agent to push a subscription, there is a schema failure. Is one DB restoration method better than another in this instance?
I am new to replication, so as much detailed information as possible would be most appreciated.
Thanx,
Chris.
July 11, 2002 at 1:59 pm
Never mind. Ihave been able to get the replication working. Turns out that it wasn't a schema failure (error), but a schema script error. Looking further into it, I found the failure to occur on a Stored Procedure - that shouldn't have been included.
Sorry,
Chris.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply