July 1, 2008 at 1:45 am
Hi,
I'm new on this site so I hope i've posted in the correct forum.
I'm trying to set up a replication test for our database. I'm using SQL Server standard 2005 X64 SP2 and SQL Server Developer 2005 X64 SP2 on the same server (default instance and REPTEST instance).
When I choose a couple of tables from our database to replicate (i'm using transactional replication) the subscriber receieved the data within a couple of seconds when initialising it for the first time.
I've now chosen the whole database (its 14GB) and started the process at 5:30pm last night. Its now 8:50am and doesnt seem to have moved. From the subscriber database if I choose to look at the status it just says "the initial snapshot publication is not yet available". I've looked in sp_who2 and there doesnt seem to be any DML commands, also the subscriber database still has no data.
Has this broken?
Thanks,
July 1, 2008 at 2:24 am
Have you tried starting the snapshot after adding rows to the replication?
July 1, 2008 at 2:31 am
I think I may have found the reason. There was 4 stored procedures that referenced invalid columns that had not been deleted. I've removed these from the publication and its now doing its bulk inserts.
Previously there was no data at all getting to the subscriber.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply