Schedule daily backup for sql server 2005 database using sql agent - Digging Technology...

JF said... @Dave You can do what you asked using this SQL script. Then you just call it from a scheduled task that runs the following command: sqlcmd -i BackupDB.sql >>%date:~10,4%-%date:~4,2%-%date:~7,2%.log--Backup all dbDECLARE @name ...

cherupally.blogspot.com