数据库备份与还原SQL代码

--备份数据库 --必须先创建Backup文件夹 DECLARE @name VARCHAR(250) SET @name = \'D:\Backup\DingHanECard_V2_ZQGDJ_\' + CONVERT(VARCHAR(50), GETDATE(), 112) + \'.bak\' BACKUP DATABASE [DingHanECard_V2_ZQGDJ] TO DISK = @name WITH NOFORMAT, NOINIT, NAME = N\'DingHanECard_V2_ZQGDJ-完整 数据库 备份\', SKIP, NOREWIND, NOUNLOAD