SharePoint 2010 restoring content database manually from sharepoint backup folder

Hello Everyone ,

In this article i am going to tell you how could you extract and restore a specific content database from backed up Sharepoint Full-Farm backup.
First lets have look our target content database which we want to restore . In my example the database name is “WSS_Content_5050” .

1) Open your Sharepoint Full Farm Backup folder. If you don’t know the backup folder  you can find  from Central Administration web site.

2) As you noticed when we order items by size in Sharepoint Full-Backup folder ( “spdbr0000”) you can see the biggest files . That files as usually  SQL backup files of sharepoint databases but which file is our content database ?

3) If you order items by Type you can find the file which we are looking for  named “spbackup.xml” .this file our backups index file in xml format.

4) than open this xml file in any editor and search your content database name in this file .

5) as you notices that “0000012A.Bak file . This is our content database’s backup file.
6) Copy this file to your SQL Server and now you can restore this file (if it is not corrupted)   via Sql Server Management Studio .

Sharepoint 2010 Restore problem with SqlException The restart-checkpoint

Object <Content Database> failed in event OnRestore. For more information, see the spbackup.log or sprestore.log file located in the backup directory. SqlException: The restart-checkpoint file ‘Drive:\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\xxxx.CKP’ could not be opened. Operating system error ‘3(The system cannot find the path specified.)’. Correct the problem, or reissue the command without RESTART. RESTORE DATABASE is terminating abnormally.

When SQL Server has been installing , it creates a default SQL Server Database backup folder like ‘Drive:\MSSQL10_50.MSSQLSERVER\MSSQL\Backup’

This error occurs that the BACKUP or RESTORE process needs to create a checkpoint file that will indicate at what point any failure occurs. This allows the WITH RESTART option to be used . The WITH RESTART option specifies that SQL Server should restart a restore operation that has been interrupted and continue restore operation where the interruption has occured . The information about how much data the BACKUP or RESTORE command had processed before the interruption occurred is stored in a checkpoint file in the BACKUP directory like ‘Drive:\<SQL INSTANCE>\MSSQL\Backup

The checkpoint file is a temporary file, deleted when the restore process is completed, and is normally placed in the default backup folder.

Some of the reasons the checkpoint file cannot be created :

– The “backup” directory does not exist under the directory where SQL Server is installed.
– The drive where the “backup” directory resides is full.
– The “backup” directory is not accessible to the SQL Server account.

For fixing the issue you may check fallowings.

– Verify that the BACKUP directory exists under the directory where SQL Server is installed. If it does not exist, create it.
– Verify that there is available space on the drive where the BACKUP directory resides.
– Verify that the SQL Server startup account has permission to read from and write to the BACKUP directory.

This error has a limited impact and does not prevent a restore operation from succeeding. This error message occurs when a restore is interrupted, and the checkpoint file that is used to restart a restore is not written, or the checkpoint file is not written correctly. If you receive this error, it means that, if for some reason the restore operation is interrupted in the middle of the process, you have to restart it from the beginning of the backup file rather than the checkpoint file.

Check fallowing KB articles for more information :
http://support.microsoft.com/?kbid=2022254
http://support.microsoft.com/kb/2083921/en-us

 

 

 

 

 

Sharepoint 2010 Backup Folder Configuration

If you are getting an error when backup operation  like  :

Cannot open backup device ‘E:\yedekk\spbr000000000BE.bak’. Operating system error 3(The system cannot find the path specified.).
BACKUP DATABASE is terminating abnormally.

Ensure that the following are given the Full Control file share and NTFS permissions for the backup shared folder:

  • The account used by the SQL Server service account.
  • The Windows SharePoint Services Timer V4 (SPTimerV4) account.
  • The logged on account, if you are using Windows PowerShell to perform the backup or restore.
  • If the backup folder is a network share, ensure that all accounts that are listed above have access to both the share and the folder itself.
  • If you are performing a backup or restore operation between two SharePoint farms, services on both farms must have the permissions described above.

Step by Step Configuration

1) Creating a backup folder where we want to store sharepoint backup files on specified computer in your domain. After that you have to share this path and create a network path .

2) If you create the shared folder on a computer other than the one running SQL Server, ensure that the service account for SQL Server (MSSQLSERVER) is using a domain user account and that it has Full Control permissions on the shared folder.Give Full Control for  SQL Server Service Account .You can find SQL Server Service Account that first connect your SQL Server -> Start -> All Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL server configuration Manager.

3)  Give Full Control to Sharepoint Timer Service Account. for do that connect your Microsoft Sharepoint Server 2010 installed machine and run-> services.msc

4) Give Full Control to The SharePoint Central Administration application pool identity account

5) Lets configure our sharepoint from Central Administration. Connect your CA and -> Backup and Restore ->
Configure Backup Settings and type your network path to “Backup File Location” section .

6) Click Ok than perform a backup .

Some Resources:
Prepare to back up and recover
http://technet.microsoft.com/en-us/library/ff806332.aspx