Sat, Dec 13 2003 10:09
Flat file backup of Sharepoint
Generally, if we restore an individual SharePoint file, we need to have a
file-based backup image of your 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
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
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
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
, 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
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 files\Common files\Microsoft shared\Web server
extensions\60\Bin\Stsadm.exe" -o backup -url http://Companyweb
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 -url http://companyweb/sites/RestoredSite
-databasename STS_RESTORE, where
DOMAIN is your server domain and administrator@DOMAIN.local
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 -url http://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, type http://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.
Filed under: Sharepoint, Needed Patches/Tweaks