명령:EXECUTE master.dbo.xp_create_subdir N''E:\Data\TIM backup & log\TIMDB''
GO
BACKUP DATABASE [TIMDB] TO DISK = N''E:\Data\TIM backup & log\TIMDB\TIMDB_backup_201005070534.bak'' WITH NOFORMAT, NOINIT, NAME = N''TIMDB_backup_20100507053454'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''TIMDB
