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): Continue reading “Advanced Restoring of Microsoft Project Server 2010 Databases” »