@Database是需要备份的数据库名,@Path是备份目录注意最后一个"/"
[vb] view plaincopy
-
use master go declare @Database nvarchar(256),@Path nvarchar(2048) select @Database=N‘AdventureWorks‘,@Path=N‘D:/TDDOWNLOAD/‘ declare @sql nvarchar(max) select @sql =N‘BACKUP DATABASE ‘[email protected]+N‘ TO DISK = ‘‘‘[email protected][email protected]+N‘_Full_‘+REPLACE(REPLACE(REPLACE(convert(nvarchar(30),getdate(),126),‘-‘,‘_‘),‘:‘,‘_‘),‘.‘,‘_‘)+N‘.bak‘‘ WITH NOFORMAT, INIT, NAME = N‘‘Full Database Backup‘‘, SKIP‘ exec (@sql) go
最后生成的备份文件
AdventureWorks_Full_2010_07_08T15_14_53_750.bak
sqlserver 备份数据库 按时间命名备份文件
原文地址:https://www.cnblogs.com/ityunwei/p/13425069.html