Database-Level Restore Prerequisites SharePoint Server Restore Configuration Settings in SharePoint Server 2010/2013/2016/2019

Before performing a database-level restore on SharePoint Server 2010/2013/2016/2019, you must satisfy the following requirements:

• Ensure that the Windows SharePoint Services Administrative service and Windows SharePoint Services Timer service are running on all the Front-End Web servers and Application servers.
• Ensure to restart the Timer service on stand-alone installations.
• If you are restoring search services and indexes to a new location, ensure that the search service is running before you start the restore.
• Ensure that all web application content databases have unique names. If a database with the same name is used by two web applications and then restored, data in the second database is overwritten with data from the first database.
• Ensure that you do not perform more than one restore at the same time.
• Ensure that all servers in Farm have the same time zone and daylight savings time settings.
• For stand alone installations, add the following accounts into the Local Administrators Group before performing a restore job. Once the restore job is completed, delete the accounts:
  • NT AUTHORITY\LOCAL SERVICE
  • NT AUTHORITY\NETWORK SERVICE

To add accounts to the Local Administrators Group

1. Open Control Panel and expand Administration Tools, Computer Management, System Tools, Local Users and Groups, Groups, Administrators.
2. Click Add.
3. Enter NETWORK SERVICE and LOCAL SERVICE.
4. Click OK.