There are many methods to backup SharePoint. You can use
HTML Administration pages to back up and restore the data in the database,
and also to schedule automatic backups for regular intervals
A. Using HTML Administration Pages to Back Up and Restore
Data
To create a database backup by using HTML Administration pages
1. On the server computer, click Start, point to Programs, point to
Administrative Tools, and then click SharePoint 3.0 Central Administration.
2. On the Central Administration page, in the left pane click on Operations.
3. Under the Backup and Restore, click on Perform a Backup.
4. On the Select Component to Backup, check what you want to backup.
5. Click Continue to Backup Operations to start the backup.
You can restore the database backup from the same Database Backup and
Restore page.
To restore a database backup by using HTML Administration
pages
1. On the server computer, click Start, point to Programs, point to
Administrative Tools, and then click SharePoint 3.0 Central Administration.
2. On the Central Administration page, in the left pane click on Operations.
3. Under the Backup and Restore, click on Restore from Backup.
4. On the Select Backup Location, browse to the location you backup before..
5. On the Select Backup to Restore, check what you want to restore.
6. Click Continue Restore Process to start the restore.
Backup SharePoint Automatically
You can also schedule an automatic backup of your database from the Schedule
Database Backup administration page.
To automatically back up the database
1. On the server computer, click Start, point to Programs, point to
Administrative Tools, and then click Microsoft SharePoint Administrator.
2. On the Server Administration page, next to the virtual server that
contains the data that you want to back up, click Administration.
3. On the Virtual Server Administration page, click Schedule database
backup.
4. Next to Automatic database backups are, select On.
5. Under Automatic database backups occur, select Daily, Weekly, or Monthly.
6. If you selected Daily, in the Time box, select the time of day to perform
the backup.
– or –
If you selected Weekly, in the Time box, select the time of day, and then in
the Weekday box, select the day of the week to perform the backup.
– or –
If you selected Monthly, in the Day box, select the day of the month, and
then in the Time box, select the time of the day to perform the backup.
7. Click Submit.
Top Of Page
Using the Command-Line Tools to Back Up and Restore Data
You can use the command line to back up and restore the database either
locally, by using Owsadm.exe, or remotely, by using Owsrmadm.exe. To back up
the database from the command line, you use the BackupDB operation. To
restore, you use RestoreDB. The BackupDB operation takes the optional
parameters –filename, -port, and –schedule. To do a simple backup of the
database on port 80, you would use the following syntax:
Owsadm.exe –o backupdb –p 80 –f path/filename
The RestoreDB operation takes the optional –filename and –port parameters.
To perform a simple restore of the same database, you would use the
following syntax:
Owsadm.exe –o restoredb –p 80 –f path/filename
You can also back up the database automatically, by creating a scheduled job
for the backup process. To schedule automatic backup you use the BackupDB
operation with the schedule parameter, and specify a time/day/month/year to
back up the database.
Note The SharePoint Timer Service is not available for FrontPage 2002 Server
Extensions on the Windows Server 2003 family platform. For that environment,
you must back up the database manually, rather than scheduling automatic
backups. If you want to automate the backup process, you can do so by
including the backup command-line string in a batch file or script.
The following example syntax shows how to set the database to be backed up
every Monday at 11:59 P.M. for port 80.
owsadm –o backupdb –p 80 –schedule "weekly at Mon 23:59"
For more information about specifying the times to use for backing up the
database, see Scheduling Timed Jobs.
