SharePoint 2007 Backup Schedule in Windows 2008

There is no feature available in Microsoft SharePoint 2007 Central adminisration to schedule the back up/restore operations.
The best method is to create a batch file, write the stsadm command for taking and storing backup on some floder of your server or netwrok folder, and finaly put that on windows task scheduler.

Open 'Notepad'

Type Following and save as "SharepointBackschedule.bat"


@echo off
echo =============================
echo Back up sites for the Server farm to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\SharePoint\

echo =============================

@SET STSADM="c:\program files\common files\microsoft shared\web server extensions\12\bin\stsadm"

cd C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\SharePoint\

@echo off

md "%DATE:/=_%"

echo ========================================

echo Directory based on the current date daytime created

echo ========================================

%STSADM% -o backup -directory "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\SharePoint\%DATE:/=_%" -backupmethod full -overwrite

echo completed


Now Click on

Click on Trigger, click on New and select the schedule (Daily/Weekly etc)

Click on the Action and click on new and browse the batch file you have created.

Click Ok

And your scheduler is ready.