Backup Script for MOSS 2007
As you have seen from previous posts, I am a big fan of Disaster Recovery planning. Having a good backup in place should allow you (and your business users) to sleep better at night... knowing that your SharePoint data is protected.
MOSS 2007 has some fantastic backup/restore functionality... but it still doesn't have a scheduler. However, it is possible, like with SPS 2003, to create a batch job to use the stsadm tool for a scheduled backup. My colleague, Nick Bisciotti, posted the script a few months back (site collection backup) so I refer you to his orginal post... http://njbblog.blogspot.com/2007/02/backup-script-for-office-sharepoint.html.
The script looks like this and is very easy to implement. Remember, check the date stamps on you files often to ensure that things are running successfully.
@echo off
echo ====================================================
echo Backup Script For Office SharePoint Server 2007
echo ====================================================
cd \program files\common files\micrsoft shared\web server extensions\12\bin
@echo off
stsadm.exe -o backup -url http://servername -filename c:\backupssharepoint\backupsharepoint.dat -overwrite
@echo off
echo completed