Menu
  1. Accueil
  2. Tech Forum
  3. Network

Restoring Project 2013 with only the SQL server component [Solved/Closed]

Report
Posts
2
Registration date
Tuesday January 12, 2016
Status
Member
Last seen
January 31, 2016
 -
Posts
2
Registration date
Tuesday January 12, 2016
Status
Member
Last seen
January 31, 2016
 -
Hello,
Hi,
I'm in need of some urgent help please! We had a Project 2013 environment consisting of 2 servers - a SQL 2012 server and a Project 2013 front end server with a full install of SharePoint 2013 and Project 2013 web app. Due to a server failure, all that I'm left with is the SQL server component.

I've built out a new SharePoint/Project server and am at a loss as to how to repoint the existing SQL data to it.
Attempting to run SharePoint configuration wizard by pointing to the existing server will see the sharepoint_config db fine, but will error out with 'Missing SharePoint products and patches' issue. The list of missing components includes MS Project Server, although it is installed. The "installed across server farm" column listed the previous name of the front end server, so in the hopes of resolving this, I renamed the new server the same with no better result.
My other attempt was to step through this article: https://docs.microsoft.com/en-us/project/restore-project-server-2013-by-using-built-in-tools?redirectedfrom=MSDN which seemed promising. Scenario One : Restoring from SQL backups is exactly my scenario, except that I don't need to restore dbs as the SQL server is intact. However, I do not get further than step one in the section after the SQL restore because opening the SharePoint Configuration Wizard throws the error 'cannot browse to the SP Cent Admin Web App because it has not been created yet':

To restore content databases in Central Administration 1.After restoring both databases, you next have to connect to a server on your SharePoint farm and open Start -> All Programs -> Microsoft SharePoint 2013 Products -> SharePoint 2013 Central Administration

If anyone has any advice or resource they can point me to, I would really appreciate it as I'm at a loss as to what to do next to bring this back online with the existing data.

Thanks!



1 reply

Answer 1 / 1
Posts
1
Registration date
Monday January 25, 2016
Status
Member
Last seen
January 28, 2016
 4
Hi,
sounds like your new installation of SP and PPM is not yet complete and working. Which steps have you taken, a full install with downloading all the prerequisites and running through a "Standard" Installation? Created a NEW config database for SP and ran through the wizard successfully? Finally, in the CA when clicking on "Manage Service applications", do you see "Project Server" and "Project Server Proxy"? Can you create a NEW Project Server site with a NEW Project Server database?
Sorry for all the questions, trying to find out where the issue is.
This site should give some options
https://social.technet.microsoft.com/Forums/exchange/en-US/d267af68-d06a-4700-bc1e-63fd30b41758/are-there-any-tools-to-recover-a-corrupted-project-file?forum=projectserver2010general
https://community.office365.com/en-us/f/172/t/265448
Regards!
4
Thank you
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Report
Posts
2
Registration date
Tuesday January 12, 2016
Status
Member
Last seen
January 31, 2016
Great! thanks!
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!