Reccomended SQL Logfile Sizing for Project Server 2003

[Tom Eckels, PMP]

Are there any reccomendations for SQL-Server-log-file sizing for Project
Server 2003? This is a relatively small implementation with 7 project
managers currently active, 10 resource managers defined for approximately 200
resources. There are usually around 40+ active projects at any time, ranging
in size/scale from small (100+ tasks) to very large (around 1000 tasks); My
DBA team is looking for justificatoin of why the database is relatively
small, but the log file is so large (and continues to fill up very quickly).

 

[NZ Projects]

The size of the log file is directly related to the number of transactions
against the database. To provide a guideline size is as such impossible for
anyone without detailed knowledge of your usage patterns.

If the size of the log file is proving to be an issue for your DBA's, I
suggest they implement a shorter time period bewteen log backups (providing
they perform log backups and the database is in full recovery mode)