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…

0

My second favorite SQL tip

Create an audit log table (or even better yet, an audit database). It can have a pretty simple structure – I often only have an artificial key, description, and date in mine. Then, when you’re executing a long running script or automated process, you can liberally add “INSERT” statements. Besides providing a log of what…

0