Scheduling Backups
Use the Central Administration site to back up SharePoint databases manually. SharePoint stores content and configuration data in separate databases, so you must use the SharePoint tools rather than the tools provided with SQL Server.
To perform a manual backup:
Navigate to the Central Administration site, click Operations, and then click "Perform a backup" under the Backup and Restore heading.
Select the item to back up and click Continue to Backup Options on the toolbar.
Select Full or Differential backup, specify a location for the backup, and click OK. SharePoint displays the Backup and Restore Status page.
SharePoint updates the status page as the backup is performed and shows the Phase as Completed when the backup is finished.
The WSS Administration and Timer services must be running in order to perform the backup. If the backup doesn't start after a few minutes, open the Microsoft Management Console (MMC) to make sure those services are running.
There is no built-in way schedule the backup process using the SharePoint timer job, so to create a backup process that runs automatically you must:
Create a command script that uses the
stsadmutility.Schedule the script to run using Windows Scheduled Tasks.
For example, the following command script performs a full backup on the current server, saves the files on the \\wombat0\spbackups share, and logs the progress of the backup in a logfile:
REM sts_backup.cmd path = %path%;C:\Program Files\Common Files\Microsoft Shared\web ...