Avoiding Project Corruption in Project Server

Although the symptoms vary, one of the main culprits is a mismatch between the version of Project Pro on users’ machines and Project Server. For example, if you deploy SP2 on the server, you must ensure that you also deploy the corresponding patch to ALL machines with Project Professional that are used to connect to…


Reattaching a Content Database Containing Project Server Project Workspaces

There’s occasions where you’ll find it necessary to reattach a content database containing a PWA site and its associated Project Workspaces. This is essential for Disaster Recovery, migration across farms, or repairing accidental contentDB detachments (or intentional ones – a lot of folks recommend disconnecting most/all contentDBs before applying a WSS/MOSS upgrade. I waive that…


Artificial Keys

How big? I’ve started noticing a lot of DBs (sometimes turning up in embarrassing places) that neglect some pretty easy scaling techniques. An often-looked consideration is designing a table to support efficient indexing. I personally find that, unless there’s a really good overriding argument, I default to creating an artificial key of the smallest numeric…


Project Server 2007 Archive DB too large?

Is your PWA Archive database too large? You may have a problem if your archive DB is significantly larger than (# of retention copies set to be maintained in your PWA’s Server Settings)  x (draft DB size) There are several things to look at: 1. How did you detect the problem? Did you run out…