Friday, 20 January 2017

DataBase Backup Query

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 

No comments:

Post a Comment