locked
Large SQL Server Database with Sync Services: Cannot reduce its size RRS feed

  • Question

  • I have a SQL Server 2008 R2 database set up with Sync Services  (using MObile devices on SQLCE ) and it is extremely  large considering the actual data it.

     

    My Database only has 35 tables and Change Tracking is enabled for 25tables  with a retention period of 5 days. (autocleanup is set to True)

     

    I Use SQL script to show me the big tables and i only have a small amout of real data (20 or so megabytes)  but SQL server is showing my database as 1.35gb with only minimal free space.

     

    No Mirroring or Transcription Log Shipping - simple out of the box install.

    Had the same problem on two other servers that where mirrored as well.

     

     

     

     

    Tuesday, February 15, 2011 2:13 PM

Answers

  • These 25 tables that have Change Tracking enabled - do they change too often? if that is the case then the internal change tracking tables maybe huge and you should look at reducing the retention period if possible. And has this size been like this from a long time or something recently changed that may have caused it to spike?
    This posting is provided AS IS with no warranties, and confers no rights
    Wednesday, February 16, 2011 8:09 AM