• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 610
  • Last Modified:

Project Server 2007 SQL Database Allocation

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.
  • 2
1 Solution
I believe the recommended is minimum of 3GB partitioned area
moronidAuthor Commented:
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.
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
moronidAuthor Commented:
Thanks for the advice.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now