아래의 쿼리를 응용하시면 될 것 같습니다..

=========================================================================

EXEC  master.dbo.xp_cmdshell 'dir *.exe'


DECLARE @backupDevice Varchar(512)

SELECT @backupDevice='c:\dbBackup\test'+ CONVERT(CHAR(8),GETDATE(),112) +'.dat'

BACKUP DATABASE testTO DISK =@backupDevice WITH FORMAT, INIT, DESCRIPTION =@backupDevice
 WAITFOR DELAY '00:00:15';
BACKUP LOG testTO DISK =@backupDevice WITH NOINIT