DECLARE @PATHNAME NVARCHAR(512),
@DATABASENAME NVARCHAR(512)
SET @DATABASENAME = 'DATABASENAME'
SET @PATHNAME = 'D:\' + @DATABASENAME + '-'
+ CONVERT(VARCHAR(8), GETDATE(), 112) + '_'
+ REPLACE((CONVERT(VARCHAR(8), GETDATE(), 108)), ':', '-')
+ '.BAK'
BACKUP DATABASE @DATABASENAME TO DISK = @PATHNAME WITH NOFORMAT, NOINIT, NAME =
N'', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
@DATABASENAME NVARCHAR(512)
SET @DATABASENAME = 'DATABASENAME'
SET @PATHNAME = 'D:\' + @DATABASENAME + '-'
+ CONVERT(VARCHAR(8), GETDATE(), 112) + '_'
+ REPLACE((CONVERT(VARCHAR(8), GETDATE(), 108)), ':', '-')
+ '.BAK'
BACKUP DATABASE @DATABASENAME TO DISK = @PATHNAME WITH NOFORMAT, NOINIT, NAME =
N'', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
No comments:
Post a Comment