MSsql语句备份

DECLARE @path varchar(200)
set @path='e:\backup\128msg_'+convert(varchar(10),getdate(),112)+'.BAK'
BACKUP DATABASE [128msg]
TO DISK =@path