Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2004
    Location
    Poland
    Posts
    35

    Unanswered: Databse replication

    Dear All

    I've made transactional replicationbetweentwo SQL 2005 servers.
    Everything looks fine, synchronization working fine, no errors, however size of replicated database file = 97 Mb,
    on Publications server the database file size = 184 Mb.

    What is wrong ?

    Best Regards
    Piotr

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    MB?

    You should be using Access
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Sounds like the equivalent of shrinking to me...
    George
    Home | Blog

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by georgev
    Sounds like the equivalent of shrinking to me...
    It's funny you talk about shrinkage, and your name is George
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    The data on the replicated server has been defragmented. behind the scenes, the snapshot bcp's out the data from the publisher, and bcp's it in to the subscriber. This removes any whitespace created by deletes and page splits.

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    That's a much more elegant way of putting it...
    I had the whole "Ya know when you defrag your PC..." conversation knocking about in my head.
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •