It is sometimes useful to issue a database backup statement from a stored procedure, or from within an SQL Task in a DTS package.

To backup a database to disk, use the following statement:

BACKUP DATABASE mydb TO DISK = 'E:\Backups\MyDB\\mydb_yyyymmdd.bak'