I wrote this to backup to a network share you can set the backup to spool to the local disk first then it will move it to another drive or to a unc just fine. Directory to hold and move to are not optional but if you set them to the same path it won't hurt the script at all.
This stored procedure will backup a single database or all databases it will also perform ether a full, diff, or tlog backup. this stored procedure is designed to take x parameters:
@dbname : required, this is the database you wish to backup null or comma seperated list
@bktype : required, this is the type of backup 0=full, 1=diff, 2=tlog @bkpath : required, this is the path can be a drive letter i.e. c:\bak or a unc \\myserver\bak
@bkpathhold: required, this is the directory that backups are spooled to first
usage
usp_backup
,2,'',''
