SQLServerCentral.com / SQL Server 2005 / SS2K5 Replication / Subscriber database size? / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 02 Aug 2015 16:36:03 GMT20RE: Subscriber database size?http://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 GMTRBarryYoungRE: Subscriber database size?http://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 GMTnoeldRE: Subscriber database size?http://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-712832RE: Subscriber database size?http://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 GMTRBarryYoungRE: Subscriber database size?http://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.Subscriber database size?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