Showing posts with label applying. Show all posts
Showing posts with label applying. Show all posts

Wednesday, March 7, 2012

Replication Monitor Bug?

There seems to be a problem with the replication monitor correctly telling you the progress of applying database schema.

Here is my setup:

Running SQL 2005 SP2. Publishing with merge replication (push) via a VPN. Approx 100 tables with lots of filtering, using data partitions filtered on host_name()

When you create and initialize a new subscription if you go to the Replication Monitor and open the Sync History window for that new subscription. You will see that it is setting up the schema in the subscriber but it does not update the status at the bottom of the window it just continually says:

Applying Database Schema - 0% complete (approzimately 00:00:00 remaining)

If it helps you can see an image of this below you will notice that it is already 15 minutes into a process that will probibly take 2 hours but it still says 0% complete.

If you require any further info or have any suggestions as to why this is not a bug (just me being dumb) please let me know.

You can see an image of this problem here: https://applications.ccusa.com/2/images/snychistory.jpg

Thanks In Advance.

Martin

Thanks Martin, can you log this issue at the connect/feedback site so we can have someone look at it?

Replication Monitor Bug?

There seems to be a problem with the replication monitor correctly telling you the progress of applying database schema.

Here is my setup:

Running SQL 2005 SP2. Publishing with merge replication (push) via a VPN. Approx 100 tables with lots of filtering, using data partitions filtered on host_name()

When you create and initialize a new subscription if you go to the Replication Monitor and open the Sync History window for that new subscription. You will see that it is setting up the schema in the subscriber but it does not update the status at the bottom of the window it just continually says:

Applying Database Schema - 0% complete (approzimately 00:00:00 remaining)

If it helps you can see an image of this below you will notice that it is already 15 minutes into a process that will probibly take 2 hours but it still says 0% complete.

If you require any further info or have any suggestions as to why this is not a bug (just me being dumb) please let me know.

You can see an image of this problem here: https://applications.ccusa.com/2/images/snychistory.jpg

Thanks In Advance.

Martin

Thanks Martin, can you log this issue at the connect/feedback site so we can have someone look at it?

Saturday, February 25, 2012

Replication issues with failed logins

I just applied instcat.sql to my SQL Srvr 2k sp4. At first it broke my replication with some cursor errors. Applying the latest instcat.sql fixed the problem, however one of the distribution agents would not start (i'm not sure if instcat had anything to do with it) giving me a "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. The process could not connect to distributor 'DistributorName'. The step failed." error.

Any suggestions would be greatly appreciated!

Thanks!

For those who experience similar problems: I simply ran distribution agent at Distributor. That fixed the issue.