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 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

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
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 files\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 -url
http://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 -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.


6 Responses to Flat file backup of Sharepoint

  1. Guy on the Scren says:

    good shit

  2. Sharepoint User says:

    I’ve been using the first method to backup sharepoint with a sync programs.

    However, Can you map a sharepoint folder when you have a https:// forcing on the site ? meaning that you can’t access it from the browser through regular http.

  3. Alejandro PAcheco says:

    This procedure didn’t work for me.

    I’m trying to restore for the same url. I’m getting a frustanting error, that the address provided is already on use.

    Then I try to another web and the site did’n work. I find the procedure is easy, but I not underestand weel the relation between all other Back/Res procedure.

  4. Jasil says:

    You may need to create a new content database if you havent already. To restore you need to have a seperate content db to restore to. For a really solid utility, check out backup Elite SC by

    hope this helps

  5. mark says:

    thanks jasil, works great

  6. Julian says: has free trials of sharepoint backup programs. give it a whirl.