Step by step backup and Restore SharePoint_Config Database in SharePoint 2013

  SharePoint_Config database contains data about the following:

·         SharePoint databases

·         Internet Information Services (IIS) web sites

·         Web applications

·         Trusted solutions

·         Web Part packages

·         Site templates

·         Web applications

Restoration of the configuration database by using the built-in backup and restore functionality is not supported in SharePoint products.

If we have not created new web applications or installed solutions then the configuration database can be successfully backed up and restored by using SQL Server or other tools if the SharePoint farm is first taken offline

Method 1.  By using SQL Server Management Studio

Backup Steps

1.      Open SQL Server Management Studio.

2.      Right Click on SharePoint_Config database, and under "Tasks" choose "Back Up"

3.      Select Backup type to "Full" to get a Full backup of database.

4.      Click "Add" to specify where to save the backup file.

5.      On the left-hand side of the window, click on ‘Options‘, and then click on ‘Overwrite all existing backup sets‘.

6.      Click "OK" to start backup.

After successfully completed we will get message that "The backup of database "SharePoint_Config" completed successfully"

 

Method 2.  By using SQL Query

Backup Steps

1.      Open-->SQL Server Management Studio

2.      Click New Query.

BACKUPDATABASESharePoint_Config

TODISK='C:\Backup\SharePoint_Config.bak'

GO

3.      Click Execute

Method 3.  By using Power Shell

Backup Steps

Backup-SPConfigurationDatabase -DatabaseName SharePoint_Config –DatabaseServer DBServerName/Instance -Directory \\server\share\Backup -Verbose

Restore SharePoint_Config Database

Restore - Similar to the configuration database it is not recommended to restore this database except in a disaster recovery scenario because of synchronization concerns.

 

Thank you very much

          Fahadullah Karimi

         SharePoint Specialist

http://sharepoint-solution-tricks.blogspot.com/

• Previous Post
• Next Post

Step by step backup and Restore Global Assembly Cache (GAC) in SharePoint 2013

Step by step backup and Restore IIS in SharePoint 2013