You need to make scheduled nightly backups using powershell or stsadm. You would like to schedule regular backups using windows scheduled but how to create the batch files to run the powershell backup. I had the same problem and I am showing you how to solve this:
PowerShell Command to backup SharePoint Site Collection
backup-spsite -identity http://SPServer:10001/ -path C:\Backup\Backup.bak
OR backup-spsite -identity http://SPServer:10001/ -path C:\Backup\Backup.bak –force (use force to overwrite existing file)
So, You can use backup-spsite to do http://SPServer:10001/ site backup. For example, the follow script will start a full backup to C:\backup where you can send site collection URL and backup file name as parameter to PowerShell Script
$args[0] = http://SPServer:10001/ and
$args[1] = C:\backup\backup_site.bak
Add-PSSnapin Microsoft.SharePoint.PowerShell
backup-spsite -identity $args[0] -path $args[1] -force
Save it as C:\Scripts\BackupSPSite.ps1 as Windows PowerShell script files are .ps1 files. And put the following inside your batch file to run from Windows Task Scheduler.
@echo off
SET SOURCE_SITE=http://SPServer:10001/
SET DEST=c:\backup\Backup_site.bak
powershell -command C:\Scripts\BackupSPSite.ps1 %SOURCE_SITE% %DEST%
Save it as C:\Scripts\BackupSPSite.bat run it from Task scheduler. In task scheduler, the account need to be set with admin permissions to run it properly.
You can use it to keep your daily backup of SharePoint Site. You can also do entire Farm backup using the following command in PowerShell Script
Backup-SPFarm -Directory C:\Backup -BackupMethod full