Project Server 2007 SQL Database Allocation

Posted on 2009-02-10
Last Modified: 2013-11-15
What is the recommended SQL disk storage for a small Project Server 2007 installation that has about 20 project managers and 500 PWA users.  Projects have an average of 100 tasks and are resource loaded.
Question by:moronid
    LVL 15

    Expert Comment

    I believe the recommended is minimum of 3GB partitioned area

    Author Comment

    I am looking for an average size to handle the project data.  There are 3 WSS databases and 4 project server databases.  And I understand the log files comsume a lot of space as well.
    LVL 13

    Accepted Solution

    Size required can vary dramatically depending on the number of projects, the use of the Project SharePoint sites, and the backup policy that you set for the Archiving database.

    The biggest variable of these is the SharePoint site usage. This is like trying to size a file server. The size can be small if users don't use this feature, but if they are storing large files here, the requirements will go up.

    The size of the log files can be managed with your SQL backup policies to some degree.

    I know this is an old question... if you have more information, I can give more details.

    James Fraser

    Author Closing Comment

    Thanks for the advice.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    At the office, we’ve started to get serious about organizing what we’re doing. I mean, it was getting to the point where every time I received a phone call, it began with “I know you’re really busy, but…” My boss was taking tasks away from me left a…
    Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now