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

 

 

 

 

 

Problem about Reporting Service (SSRS) for SharePoint 2010 Integration

Recently i faced fallowing error and decided that write about an article about SSRS with Sharepoint Integration because of MSDN articles is very detailed but sometimes the people can miss the basic points.Lets see what we faced:

The configuration parameter SharePointIntegrated is set to True but Share Point Object Model cannot be loaded.

System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’ or one of its dependencies. The system cannot find the file specified. File name: ‘Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’ at Microsoft.ReportingServices.SharePoint.Objects.RSSPImpSecurity.set_StaticCatchAccessDeniedException(Boolean value) at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelper..ctor() at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelperFactory.get_ServiceHelper() WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. . (rsSharePointObjectModelNotInstalled) Get Online Help

The cause of the problem is the server which SSRS installed has not  sharepoint installation.SSRS server and the sharepoint technology instance are on separated machines.If you deep in MSDN articles you can find fallowing informations :

You plan to immediately install the Reporting Services Add-in and configure report server integration settings on the SharePoint site. If the report server provides report processing capability to a SharePoint farm, you must also install a SharePoint Web front end on the report server computer so that you can join it to the farm
http://technet.microsoft.com/en-us/library/cc281311.aspx
“For deployments that include a SharePoint server farm, install a SharePoint Web front-end on the report server computer. The Web front-end joins the report server computer to a SharePoint farm. Installing the Web front-end on the report server computer is only necessary if you deploy the report server and the SharePoint technology instance on separate computers.”
Configuring Reporting Services for SharePoint 2010 Integration http://technet.microsoft.com/en-us/library/bb326356.aspx

Conculution:
So the SSRS server must be a member of the sharepoint farm. In order to join the farm, the farm must aware of the SSRS server. So we need to install the sharepoint web front-end on the SSRS server to make it able to communicate with other machines.

Please check for more info:
Requirements for Running Reporting Services in SharePoint Integrated Mode
http://technet.microsoft.com/en-us/library/bb283190.aspx

 

About Sorting problem on Picture Library in Sharepoint 2010 after installing Dec 2011 CU

Hello Everyone,

We have a problem for sorting on Picture Libraries in Sharepoint 2010 . I have tested the issue SPS2010 + SP1 + Dec 2011 CU and can be easly reproducable.
The problem is when you click “Column” links or click popup window Ascending or Descending links nothing happens .Thats mean you can not able to sort items in Picture Libraries.
As far as i know it was working on SP1 level . The problem has occuring after CU upgrade.

Does any fix ? Not yet .(12/03/2012) I am expecting but not sure in June CU 2012 will fix the issue.
So until then you can use fallowing workaround to fix issue.

It is very simple wsp file created as site scope that dispatching postback events on picture libraries by using Jquery.
You can download WSP or Source project form Codeplex.
http://spssampleprojects.codeplex.com/releases/view/84054

For installing solution:

1) Download “PictureLibraryFix.wsp” file to c: drive of your sharepoint server

2) Open a Sharepoint Management Shell and

3) Type fallowing for adding solution to sharepoint
Add-SPSolution -LiteralPath c:\PictureLibraryFix.wsp

4)Type fallowing for installing solution:
Install-SPSolution -identity picturelibraryfix.wsp -GACDeployment

5)Type fallowing for enable feature on specific site collection:
Enable-SPFeature -Identity 8af7cb42-0fc7-4aa6-91e8-e1d1993b34cc -url http://blog.bugrapostaci.com