Project Server 2007 SQL Database Allocation

Posted on 2009-02-10
Medium Priority
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
  • 2
LVL 15

Expert Comment

ID: 23605250
I believe the recommended is minimum of 3GB partitioned area

Author Comment

ID: 23611292
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

jbfraser earned 2000 total points
ID: 23910140
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

ID: 31545197
Thanks for the advice.

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Article by: x-men
Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

864 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