SQL Server DB Backup Schedule

주기백업시 SQL Server Agent에 등록 (T-SQL)

파일명은 정해진이름+일자.bak 형태로 백업됨

DECLARE @QUERY VARCHAR(2000)

,       @DATE VARCHAR(10)

SET @DATE = SUBSTRING(CONVERT(VARCHAR,GETDATE(),112),1,4) + '.' +

                       SUBSTRING(CONVERT(VARCHAR,GETDATE(),112),5,2) + '.' +

                       SUBSTRING(CONVERT(VARCHAR,GETDATE(),112),7,2)

SET @QUERY = '

BACKUP DATABASE [DB_NAME] TO  DISK = N''' + 'F:\BAKUPFILE_NAME_'+ @DATE +'.bak''

WITH NOFORMAT, NOINIT,  NAME = N''DBNAME 전체데이터베이스백업'', SKIP, NOREWIND, NOUNLOAD,  STATS = 10 '

EXEC (@QUERY)