How do I check Project Server 2007 database integrity and find errors?

Wil_Jansen
Wil_Jansen used Ask the Experts™
on
My Project Server 2007 databases probably have some integrity errors. Olap cube building causes SQL server tempdb to grow unlimitedly, pointers in Enterprise Global point to wrong views and tables.
Is there a way or a tool to check database integrity for Project Server 2007 databases?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Use DBCC CHECKDB on the ms project database. It checks the logical and physical integrity of all the objects in the specified database.
Connect to the project server db and run following:

DBCC CHECKDB;
Commented:
Wil,

The problems you describe are often not caused by database integrity issues:

The OLAP build consuming TempDB:
http://blogs.msdn.com/brismith/archive/2008/03/24/slow-olap-cube-builds-and-large-tempdb-revisited.aspx

Problems with views when editting the EGT:
http://blogs.msdn.com/brismith/archive/2009/06/29/project-2007-mixed-up-views-after-updating-the-enterprise-global-after-sp2.aspx

Let us know if these seem to address your problems.


James Fraser
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

Commented:
Wil,

Were you able to resolve your issues?


James Fraser

Author

Commented:
It is ok to close because James Fraser supplied a good answer.

Commented:
Wil,

When an answer is provided that solves your problem, you should "Accept solution" to award points to the person supplying that answer.


Thanks!
James Fraser

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial