InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 13:23:02 GMT20http://www.sqlservercentral.com/Forums/Topic714502-291-1.aspx[quote][b]jliu (5/12/2009)[/b][hr]Thank you both for your replies. I randomly checked a few tables between the publisher and the subscriber, they seemed to match. I will run the sp to validation the publication, but this certainly puts my mind at ease :-)[/quote]Glad we could help.Wed, 13 May 2009 13:27:36 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic714502-291-1.aspx[quote][b]jliu (5/12/2009)[/b][hr]Thank you both for your replies. I randomly checked a few tables between the publisher and the subscriber, they seemed to match. I will run the sp to validation the publication, but this certainly puts my mind at ease :-)[/quote]Keep in mind that validation procedures are useful only at times where no changes are happening on the primary.Wed, 13 May 2009 12:21:48 GMTnoeldhttp://www.sqlservercentral.com/Forums/Topic714502-291-1.aspxThank you both for your replies. I randomly checked a few tables between the publisher and the subscriber, they seemed to match. I will run the sp to validation the publication, but this certainly puts my mind at ease :-)Tue, 12 May 2009 08:22:58 GMTjliu-712832http://www.sqlservercentral.com/Forums/Topic714502-291-1.aspxSize of the databases can also include much unused and unallocated space. And the tables themselves can also can varying amounts of currently unused space. Liewise, Indexes can be quite different as well.If you suspect that a table is not fully replicated, start by comparing the RecordCounts of the two tables.Mon, 11 May 2009 23:03:06 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic714502-291-1.aspxHi Jason,Size of the database need not match. Database has many other objects, not just tables.Run sp_publication_validation to check.SureshMon, 11 May 2009 22:55:03 GMTSuresh B.http://www.sqlservercentral.com/Forums/Topic714502-291-1.aspxHello, I have 3 separate SQL servers (2 SQL 2005 and 1 SQL2000) handling the one way transactional replication process. Publisher and Subscribers are running on separate SQL 2005 servers while the distributor is running on a SQL 2000 server. I'm replicating all tables for this database on a daily basis and the status always indicates replication has been successfully applied. But the physical size of the drive is only about 1/4 of the publisher's database size. I'm concern that not all the data has been replicated over. Is this behavior normal? How do I check the integrity of the subscriber DB?*Snapshot are taken and applied only if i reinitialize the subscription, so it doesn't happen too oftenThank you in advance,JasonMon, 11 May 2009 14:29:54 GMTjliu-712832