how to recover sharepoint database

Posted by fierce at 2020-02-29

"I am using SharePoint 2010 and trying to restore a mdf . I found some tips to repair SharePoint database by manually 1. I tried to attach the .mdf from SharePoint by removing the log file item from database to attach list; 2. Create Database Monitoring ON (FileName = N'D:\Dump\Data\Monitoring.MDF') For Attach_Rebuild_Log, 3. sp_attach_single_file_db N'Monitoring', N'D:\Dump\Data\Monitoring_Data.MDF' But it's very complicated to repair corrupt mdf. by manually. Then I found some tool to repairing a corrupt mdf file automatically. And now, I want to recover SharePoint database. How can I do it?" ----- Answers Yahoo There few programs online that can help you recover SharePoint database, but it is not the case with Stellar Phoenix SharePoint Server Recovery which can recover your valuable SharePoint data, including business critical documents, site content, and metadata. Stellar Phoenix SharePoint Server Recovery can safely repairs SharePoint databases or SQL Server files to retrieve all crucial information stored on your SharePoint Server. The software can easily extract all data and documents from the damaged SharePoint database. Repairs .MDF database of the SharePoint Server SharePoint Server uses SQL databases to store data of all site collections, document libraries, and lists. Any damage to these SQL databases ('.MDF' files) causes crippling loss of SharePoint data. The software effectively fixes all corruption in the MDF file to recover all your vital SharePoint data. 'Complete Repair' Option The software facilitates complete recovery of your SharePoint content database, restoring the content of all sites in a site collection and any uploaded documents, such as blogs, wikis, and articles. The software efficiently recovers all tables in the SharePoint database maintaining the integrity of your precious data. 'Document Recovery' Option This software enables you to smoothly repair SharePoint databases and recover dozens of documents present in multiple libraries within the SharePoint sites. The software displays a list of all documents in the selected content database and allows recovering only a few specific documents of choice. Searches for SharePoint Databases The software incorporates a 'Search File' feature to search and locate MS SQL MDF files in a particular drive of your system. You can also search in sub-folders within the folders to quickly find out the desired SharePoint database for recovery. Preview of SharePoint Data The software shows preview of SharePoint data (i.e. contents of all recovered database tables and attached documents) after scanning your damaged database. The preview of database contents helps you judge the efficacy of the software and verify your data prior to saving the recovered data. Uploads Database files to SharePoint Server The SharePoint Server recovery software ensures that you get the desired results with minimum effort. It gives you an option to attach the recovered database file to the web application on the server. This saves your considerable time required to upload the database files to the SharePoint Server. Option to View and Save Log The software keeps track of all activities performed during the SharePoint repair process by maintaining a log report. It gives you the choice to view this log or save it as a '.txt' file in your system. You can also clear this log at any point of time.