Showing posts with label recover SharePoint. Show all posts
Showing posts with label recover SharePoint. Show all posts

Wednesday, April 24, 2013

How to recover SharePoint database when STSADM MergeContentDBs cause corruption


STSADM MergeContentDBs command allows users to move a site collection from one content database to another. You have to specify the source and destination parameter properly. In some situations, STSADM MergeContentDBs command fails to work properly and cause database corruption. Due to failure of this command both source and destination database may also got damaged. STSADM MergeContentDBs command fails when there is high load on SQL Server or high user traffic. When you run this command on database whose size is larger than 10GB then also there are high chances of database corruption.

Solution:
To resolve the issue, keep following points in mind while using  STSADM MergeContentDBs command:
  1. Make sure to backup the source and destination database before using the  STSADM MergeContentDBs command
  2. Do not cancel the operation in middle of server that is running SQL Server.
  3. Since  STSADM MergeContentDBs command put extra load on server that is running SQL Server so using it during non production hours.
The above steps are basically prevention steps that will help you in avoiding corruption when next time you use this command but if your database already got corrupted due to failure of  STSADM MergeContentDBs command then you can try a good third party SharePoint recovery software. There are many professional third party tools available online that can easily repair damaged SharePoint database and also provides free demo version.

Tuesday, January 29, 2013

Recover data from corrupt SharePoint databse with Stellar Phoenix SharePoint Recovery


If you are using SharePoint for storing and sharing your data then I hope that you must be aware of the importance of data. What will you do if your SharePoint database suddenly got corrupt? Most probably, you will try to restore your data from backup. But wait, what if the backup is also not available? Don't stress there is still a way out. You can repair & restore your data by using an ultimate third party tool named Stellar Phoenix SharePoint Server Recovery. It repairs corrupt database and create a new mdf file.

Features:
  • Repairs damaged SQL database: Since SharePoint store all the documents, lists and site collection in SQL database so if it got damaged, your website may become inaccessible. Stellar Phoenix Server recovery software fixes all the corruption and create a new mdf file. You can then incorporate repaired mdf file in to SharePoint server.
  • Search option: If you forgot the location of your damaged mdf file then you can search for it in all the folders and drives using software 'Search' option.
  • Complete Recovery: This option is use to repair damaged database. It scan the database for damaged tables and then repair them. The repaired table will be saved in a new mdf file.
  • Document Recovery: Using this option you can recover all your website contents like wiki, blogs, documents etc. 
  • Display Preview: After scanning, you can see the preview of all the recoverable items.
  • Generate Log Report: This software create log of all the activities performed during repair process. You can save the log report for future reference.
  • Attach file option: After the completion of recovery process you can attach your repair database file back to server.
  • SharePoint software support: Supports recovery of SharePoint 2010 & 2007.

Steps to repair corrupt SharePoint database:

     1.  After installing the software click on 'Complete Repair' option.


   2.  Click on 'Select File' button to select corrupt mdf file.


  3.  Now scan the file by clicking on 'Scan File' button.
  4.  After scanning, you can see the preview of all repairable objects.


  5.  Repair the file by clicking on 'Repair' button.
  6.  After successful repair 'Recovery process successfully completed' message will appear, click Ok.


  7.  Again 'Do you want to add...' message appear, click Yes if you want to attach new mdf file to SharePoint Server.

Related Posts Plugin for WordPress, Blogger...