<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
SS2K5 Replication
»
Subscriber database size?
Subscriber database size?
Rate Topic
Display Mode
Topic Options
Author
Message
jliu-712832
jliu-712832
Posted Monday, May 11, 2009 2:29 PM
Forum Newbie
Group: General Forum Members
Last Login: Friday, April 20, 2012 11:40 AM
Points: 2,
Visits: 142
Hello,
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 often
Thank you in advance,
Jason
Post #714502
Suresh B.
Suresh B.
Posted Monday, May 11, 2009 10:55 PM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 4:49 AM
Points: 1,075,
Visits: 5,119
Hi Jason,
Size of the database need not match. Database has many other objects, not just tables.
Run sp_publication_validation to check.
Suresh
Post #714715
RBarryYoung
RBarryYoung
Posted Monday, May 11, 2009 11:03 PM
SSCrazy Eights
Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855,
Visits: 9,374
Size 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.
-- RBarryYoung
,
(302)375-0451
blog:
MovingSQL.com
, Twitter:
@RBarryYoung
Proactive
Performance Solutions, Inc.
"Performance is our middle name."
Post #714719
jliu-712832
jliu-712832
Posted Tuesday, May 12, 2009 8:22 AM
Forum Newbie
Group: General Forum Members
Last Login: Friday, April 20, 2012 11:40 AM
Points: 2,
Visits: 142
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
Post #715125
noeld
noeld
Posted Wednesday, May 13, 2009 12:21 PM
SSCertifiable
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:39 PM
Points: 6,260,
Visits: 1,977
jliu (5/12/2009)
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
Keep in mind that validation procedures are useful only at times where no changes are happening on the primary.
* Noel
Post #716294
RBarryYoung
RBarryYoung
Posted Wednesday, May 13, 2009 1:27 PM
SSCrazy Eights
Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855,
Visits: 9,374
jliu (5/12/2009)
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
Glad we could help.
-- RBarryYoung
,
(302)375-0451
blog:
MovingSQL.com
, Twitter:
@RBarryYoung
Proactive
Performance Solutions, Inc.
"Performance is our middle name."
Post #716364
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
