SQL Server 数据库备份命令
DECLARE @DataStr NVARCHAR(200)
SET @DataStr = CONVERT(NVARCHAR(19), GETDATE(), 120)
SET @DataStr = REPLACE(@DataStr, ':', '')
SET @DataStr = REPLACE(@DataStr, ' ', '')
SET @DataStr = REPLACE(@DataStr, '-', '')
SET @DataStr = 'D:\SqlData\Bak\eonedbx_3_' + @DataStr + '.bak' --备份文件保存路径和名称
BACKUP DATABASE [数据库名] TO DISK = @DataStr WITH
NOINIT, NOUNLOAD, NOSKIP, STATS = 10, NOFORMAT