Forum Discussion

john john's avatar
john john
Iron Contributor
Apr 19, 2019

Can we restore a corrupted farm from the backups we have for sharepoint databases

One of our customers use to have a sharepoint enterprise farm 2013, with the following architecture:- 1. windows 2008 R2 which contain sharepoint on-premises farm 2013. 2. windows 2008 R2 which con...
2013
admin
Backup
sharepoint server
Maruthi Gadde's avatar
Maruthi Gadde
Iron Contributor
Apr 19, 2019

john john 

  • since only your application server is down , you can join a new server to the farm and force all application services to run on the new server.
  • if your concern that ca is on the app server, you can run the psconfig on any of the other sharepoint server and setup the ca on the server

if you plan to spin a new farm, except the config dB you should be able to restore most of the service application and all content databases. 

 

If if you are rebuilding a complete farm, and you need the build version number, restore the config dB on a test sql server and query the config dB. Direct querying the prod sharepoint sql databases are not supported so suggesting restoring it to a test sql database.

  • john john's avatar
    john john
    Iron Contributor
    Apr 19, 2019

    Maruthi Gaddethanks for your useful reply, please find my comments on your points:-

     

    since only your application server is down , you can join a new server to the farm and force all application services to run on the new server.

    I am not sure what do you exactly mean by join a new server to the farm? now the only application server they have can not be used anymore as it had a sever damage. So are you saying that i need to create a new VM and install sharepoint inside it?if the answer is yes, then i need the sharepoint to have the same patches as the damaged server, and this info is not available, as mentioned on my question.

     

    if your concern that ca is on the app server, you can run the psconfig on any of the other sharepoint server and setup the ca on the server

    yes the Central admin is on the application server which had the sever damage .. not sure if i got your point correctly..

     

    if you plan to spin a new farm, except the config dB you should be able to restore most of the service application and all content databases.

    yes i think i will need to create a new application server, which will have the Central admin and all the other application services; search, managed metadata, etc.. i do not think we have any other option.. is this correct? also i am not sure what do you mean by `except the config dB`?

     

    If if you are rebuilding a complete farm, and you need the build version number, restore the config dB on a test sql server and query the config dB. Direct querying the prod sharepoint sql databases are not supported so suggesting restoring it to a test sql database.

    but will the config DB contain the info about the patches we need to install to get an exact copy of the damaged application server?

Resources