none
What would cause a sudden increase in the published database?

    Question

  • Our DBA found a sudden need to increase space as a result of using Ignite on the server. What are the possible reasons for such a large increase for this table?

    Friday, November 02, 2012 8:41 PM

All replies

  • After the project server was provisioned, did you enter any projects or migrate any thing from PS200.

    cheers


    Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA, MCC 2011, MCC2012
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Sunday, November 04, 2012 10:46 PM
    Moderator
  • Michael,

    We migrated from Project Server 2007 one year ago.  This increase has been noticed only lately.  Do you have any other suggestions?

    Thanks,

    Tom

    Monday, November 12, 2012 9:45 PM
  • Hi there,

    What patch level are you? There was a fix for this back in October 2011: http://support.microsoft.com/kb/2596531 and another fix in the February 2012 CU (KB includes bulk SQL clean up script): http://support.microsoft.com/kb/2598007

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Monday, November 12, 2012 10:05 PM
    Moderator
  • We are patched to Aug 2012 CU.  I will take a look at the bulk cleanup script to see if there is something in that routine that could help.

    Thanks,

    Tom

    Tuesday, November 13, 2012 12:11 PM