SQL 备份与还原 如何用脚本语言写？

SQL 备份与还原 如何用脚本语言写？

--完整备份(name还原显示的名称)
backup database t to disk='E:\dataBak\log\bak_t_full.bak'
with noinit,name='bak_t_full'
--差异备份
backup database t to disk='E:\dataBak\log\bak_t_differ.bak'
with differential,noinit,name='bak_t_differ'
--日志备份
backup log t to disk='E:\dataBak\log\bak_t_log.bak'
with noinit,name='bak_t_log'
--还原
RESTORE DATABASE 数据库名 FROM DISK = '物理路径(备份文件在磁盘的位置)'

use master go if object_id('sp_restoredb') is not null drop proc sp_restoredb go create proc sp_restoredb( @dbname sysname,--数据库名 @restorefiles nvarchar(1000)--路径如：c:\ ) as declare @s nvarchar(4000),@backname nvarchar(200) set @backname='backup'+convert(varchar(8),getdate(),112)+'.bak' set @s='backup database ['+@dbname+'] to disk = n'''+@restorefiles+@backname+''' with noformat, noinit, skip, norewind, nounload, stats = 10' exec(@s)