网站首页 博客 SqlServer备份数据库命令
SQL Server备份数据库命令
declare @filename varchar(1024); declare @path varchar(1024); set @path = N'D:\DataBackup\'; declare @extension_name varchar(16); set @extension_name = N'bak'; set @filename = convert(varchar(1024), getdate(), 120); set @filename = replace(@filename, ':', ''); set @filename = replace(@filename, '-', ''); set @filename = replace(@filename, ' ', ''); set @filename = @filename + '_' + convert (varchar(3), datepart(ms, getdate())) + N'.' + @extension_name; set @filename = @path + 'mydbname_' + @filename; backup database [mydbname] to disk = @filename with noformat, noinit, name = N'mydbname完整备份', skip, norewind, nounload, stats = 10, COMPRESSION
使用方法:
开启SQL Server代理服务(SQLSERVERAGENT)
SQL Server代理->作业->新建作业->步骤->新建T-SQL脚本