sql数据库备份/恢复脚本
2020-09-01 22:27:13
749 收藏
数据库备份
02 | declare @dbname varchar(40) |
04 | declare @bakpath varchar(400) |
06 | select @dbname='zw0001' |
07 | select @bakpath='d:\bak' |
09 | select @date=convert(varchar(8),getdate(),112) |
10 | select @bakpath=@bakpath+'\'+@date+@dbname+'.bak' |
11 | exec (' USE MASTER BACKUP DATABASE '+@DBNAME+ ' TO DISK = N'''+@bakpath+''' WITH INIT , NOUNLOAD , NAME = N'''+@dbname+''', |
数据库恢复
02 | declare @DBname varchar(40) |
03 | declare @FLname varchar(40) |
04 | declare @bakpath varchar(400) |
06 | select @dbname='zw0001' |
07 | select @FLname='zw0001.bak' |
08 | select @bakpath='d:\bak' |
10 | select @bakpath=@bakpath+'\'+@FLname |
11 | exec (' USE MASTER RESTORE DATABASE '+@DBNAME+ ' FROM DISK = N'''+@bakpath+''' WITH FILE = 1 , NOUNLOAD , STATS = 10, RECOVERY , REPLACE ' )
|
