FYI, replication errors resolved...

FYI, replication errors resolved...

Post by Kenny Kao » Sun, 02 Jun 2002 15:44:01

In the last few days I have posted several questions reguarding
different issues while setting up replication. I just wanted to tell you
and more important, those who are trying the same thing I did, what
worked and what did not.

My scenerio, 1 sql 7.0 box on a nt 4.0 platform server running today,
serving multilple sites.

Goal, migrate to win2k OS but using sql7 and establish 2 servers with

What I did, that didn't work. I built the two servers, and installed
identical configurations, hardware and software respectfully named
sqlserver01 and sqlserver02. Backed up the database from the existing
box and restored it to both servers. {Just seemed to reason to me that
this would be the best thing to do}

To make is short and sweet, after hours and hours of issues and errors
while trying to replicate, I decided at 4:30 this morning to uninstall
SQl from server 2 and create an empty database with out the tables and
data. Then attempt to replicate the data in to the empty data base.

This worked perfectly, only too a few minutes to replicate almost 300
meg's of data.

I hope this helps someone, and I hope you guys don't mind me posting it
here. If someone needs more detail about what I did, feel free to email
me directly.

Kenny Terry

Posted via dBforums


1. replication error - how to resolve?

I added a PK to a table on both the publisher and the subscriber
This table is being replicated via a weekly snapshot.  The snapshot only
on Sunday mornings, yet I got this message this morning:

Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such
 as CREATE FILE) operations on a database must be serialized. Reissue
 statement after the current backup, CHECKALLOC, or file manipulation
 operation is completed.

How do I resolve this?


2. Profiler Filters Not Working?

3. FYI the Solution - Replication was failing

4. ASCII copy of DDL and data

5. FYI - removing replication

6. find who is the user in trigger procedure

7. FYI some replication info that you will not find in Books Online

8. MAX MRP btreive to VB?

9. FYI the Solution - Replication was failing

10. Orlacle 9i lite replication - resolving conflicts

11. How to resolve replication problems in SQL 7.0

12. How to resolve replication conflicts ???

13. Resolving Conflicts in a Merge Replication