Microsoft Project Server, SharePoint, Security and other cool things…

Rolly Perreaux

   LinkedIn - MVP-Press Networking Group   @RollyPerreaux   RSS Feed    


Archive for March, 2012

Advanced Restoring of Microsoft Project Server 2010 Databases

Posted on March 30, 2012 by

As many of you already know, restoring a Project Server 2010 database can be done a few ways:

  • SharePoint Central Administration
  • SQL Server Management Studio

And this is all fine if you are restoring the database from the same server.

But what happens if you attempt to restore the databases from a different SharePoint/SQL Server and possibly from a different domain? How about working in an isolated Dev environment and wanting to restore the database into production? While this is a very unlikely scenario in a production environment, nevertheless what would happen if you had to rebuild your network domain infrastructure?

Here’s a hint: we know that Active Directory GUIDs are used for Project Server users to access PWA, so if the GUIDs are changed in any way there will be no access to PWA and would receive the following error (that includes the Administrator): Read the rest of this entry →

↑ Top