We help IT Professionals succeed at work.

Project Server 2007 SQL Database Allocation

moronid
moronid asked
on
Medium Priority
637 Views
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.
Comment
Watch Question

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

Author

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.
Commented:
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Thanks for the advice.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.