Recovering configuration and service databases

Configuration and service databases must be synchronized with other databases. Hence, it is recommended to recover configuration and service databases either along with content databases or to the latest point in time (if content databases do not need recovery).

The configuration database contains hostnames of the farm's servers. Therefore, you can recover the configuration database only to the original SharePoint farm. Service databases can be recovered to a non-original farm.

To recover the configuration database

On the server that is running the Central Administration site, in the Services snap-in, stop the services listed in the table below.
On the server that is running the Central Administration site, run the following command:
iisreset /stop
Recover the database files as described in "Recovering SQL Server databases from a disk backup".
Start the SharePoint services that were stopped earlier.

SharePoint 2007 services	SharePoint 2010 serivces	SharePoint 2013 services
Microsoft Single Sign-On Service Office Document Conversions Launcher Service Office Document Conversions Load Balancer Service Office SharePoint Server Search Windows SharePoint Services Administration Windows SharePoint Services Search Windows SharePoint Services Timer Windows SharePoint Services Tracing Windows SharePoint Services VSS Writer	SharePoint 2010 Administration SharePoint 2010 Timer SharePoint 2010 Tracing SharePoint 2010 User Code Host SharePoint 2010 VSS Writer World Wide Web Publishing Service SharePoint Server Search 14 SharePoint Foundation Search V4 Web Analytics Data Processing Service Web Analytics Web Service	SharePoint Administration SharePoint Timer SharePoint Tracing SharePoint User Code Host SharePoint VSS Writer World Wide Web Publishing Service SharePoint Server Search

To recover a service database

Stop the services associated with the database you want to recover. To do so:
1. Open Central Administration site.
2. Do one of the following:
  In SharePoint 2010 or later, select System Settings > Manage services on server.
  
  In SharePoint 2007, select Operations > Services on server.
3. To change the server on which you want to stop the service, in the Server list, click Change Server, and then click the required server name.
4. By default, only configurable services are displayed. To view all services, in the View list, click All.
5. To stop a service, click Stop in the Action column of the relevant service.
6. Click OK to stop the service.
Recover the database files as described in "Recovering SQL Server databases from a disk backup".
Start the services associated with the database, similarly to step 1.