Transactional Replication: Publisher & Subscriber size mismatch

15 pts.
Tags:
Hard drive space
SQL 2005
SQL Database
SQL Server
SQL Server 2005
SQL Server 2005 Database
Hello,

We have implemented transactional Replication[Push] on our SQL Server 2005 DB. The Distributor is the Publisher. The publisher is on one server and the subscriber on another. After synchronizing the DB, the tables count and the no of recs per table are identical on both the servers, however the actucal db size on the hard drive in much different. Any help will be much appreciated. Thanks in advance.



Software/Hardware used:
SQL Server 2005
ASKED: August 2, 2010  12:26 PM
UPDATED: August 5, 2010  6:02 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

This is normal and isn’t something to worry about.

The tables on the subscriber are written in a different order than the tables were on the publisher, and the tables on the publisher probably have a lot more white space hidden through out the database file than the subscriber does.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Test12
    Thanks a lot for the reply Mrdenny.
    15 pointsBadges:
    report
  • Test12
    [...] Test12 inquired about publisher and subscriber size mismatch during transactional replication on SQL Server 2005; Mr. Denny assured him it’s [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following