Flat File Backup of Share Point
Credits: Taken from a SBS BLOG on the net.
Generally, if we restore an individual SharePoint file, we need to have a file-based backup image of our SharePoint documents. As I know, there are two ways to perform file-based backup for your SharePoint database. For your convenience, I included the methods below:
Method 1. Use NTBackup.
=====================
According to our test, we can map the folders under \\companyweb as network drives now. Thus, we can use NTBackup to back up or restore the files in these folders (network drives) directly. To do so, please follow the steps below:
1. Map the \\Companyweb\Foldername folder as a network drive
2. Run NTBackup and back up the network drive.
3. When you need to restore one file in this folder, simply run NTBackup to restore
Method 2. Use Stsadm.exe.
=====================
If you have enabled the recovery of SharePoint files, you can recover a file or list item by restoring the entire site from a backup to a subsite of http://companyweb, selecting the file or list item that you want to restore, extracting it, and uploading it to its original location. To enable the recovery of individual SharePoint files, please use the following procedure:
1. Click Start, click Control Panel, click Scheduled Tasks, and then click Add Scheduled Task.
2. Click Next on the first page of the Scheduled Task Wizard.
3. Click Browse, go to %SystemDrive%\Program Files\Common Files\Microsoft Shared\Web server extensions\60\Bin, and then double-click Stsadm.exe.
4. Select how often you want this task to run, and then click Next.
5. Select the time you want to run the schedule, and then click Next.
6. Enter administrator credentials, and then click Next.
7. Select the Open advanced properties when I click finish check box, and
then click Finish.
8. On the Task tab in the dialog box that appears, in the Run box, type "%SystemDrive%\Program iles\Common files\Microsoft shared\Web server extensions\60\Bin\Stsadm.exe" -o backup -url http://Companyweb -filename target path -overwrite, where target path is where you save the backup of your internal Web site. Click OK. You must type the quotation marks.
If you have enabled this before, you can follow the steos below to restore
the missing files:
1. Click Start, click Command Prompt, and then type "%SystemDrive%\Program files\Common files\Microsoft shared\Web server extensions\60\Bin\Stsadm.exe" -o createsiteinnewdb -urlhttp://companyweb/sites/RestoredSite -ownerlogin DOMAIN\administrator -owneremail administrator@DOMAIN.local -databasename STS_RESTORE, where DOMAIN is your server domain and administrator@DOMAIN.local is your administrator¡¯s e-mail address. Include the quotation marks as part of the path. Press ENTER.
2. Type "%SystemDrive%\Program files\Common files\Microsoft shared\Web server extensions\60\Bin\Stsadm.exe" -o restore -urlhttp://Companyweb/Sites/Restoredsite -filename target path -overwrite, where target path is the location where you chose to save your SharePoint backup. Include the quotation marks as part of the path. Press ENTER.
3. Open Internet Explorer, and in the address bar, typehttp://Companyweb/Sites/Restoredsite. The site that appears is the same as your company Web site.
4. In the restored site, navigate to the missing file.
5. Right-click the file, select Save Target As, and then select a location to which to save the file.
6. Repeat steps 4 and 5 for all missing files.
7. Open your company Web site, navigate to the location where the missing files should be, and then on the SharePoint toolbar, click Upload Document.
NOTE: The second method is provided in the SBS Server help. You can find this by the following steps:
1. Open Server Management.
2. Click Standard Management->Backup.
3. Click Restore Sharepoint files in the right pane.
However, if you have not performed either method above to enable file-based backup, I am afraid that we may have to restore the entire database.