Restore deleted files in SharePoint document library through backup database
Author：Eve Cole
Update Time：2009-05-31 00:06:43
Today, a colleague accidentally deleted an important file in the SharePoint document library and needed to recover it.
The method I am thinking of is to restore through the previous day's SharePoint database backup. The specific recovery steps are:
1. Restore the database backup to a test computer.
2. Open the site database, find the record that needs to be restored in the docs table, and write down the value of the id field.
3. Use the export function of SQL Server to export the records that need to be restored from the docs table of the backup database to the docs table of the target database.
4. Select "Open" in the file menu of IE, enter the address of the document library where the deleted file is located and select "Open as Web Folder File", click "OK", and then open "Document Library", you will see For the deleted file, copy the file to the local computer, and then paste it into the "Document Library" just opened to overwrite the existing file. In this way, the file can be seen on the Web page, and the recovery work is completed.
