MS_SQL DB 백업 쿼리

USE Database

-- 변수선언

declare @Path nvarchar(200)
declare @DBName nvarchar(100)
declare @FileName nvarchar(100)
declare @TXFileName nvarchar(100)
declare @FullFileName nvarchar(200)
declare @TXFullFileName nvarchar(200)

--경로 설정

set @Path = 'D:\DB\백업'
set @DBName = 'Database'

set @Path = @Path + N'\'

set @FileName = @DBName + N'_Backup_' + CONVERT(varchar(10), getdate(),120)  --DB 백업
set @TXFileName = @DBName + N'_TX_' + CONVERT(varchar(10), getdate(),120)  --로그 백업

--백업파일 이름 설정

set @FullFileName = @Path + N'\' + @FileName + N'.Bak'
set @TXFullFileName = @Path + N'\' + @TXFileName + N'.trn'

--백업 명령어
backup database @dbname to disk = @FullFileName with noformat, noinit, name = @FileName , skip , rewind, nounload, stats = 10
backup log @Dbname to disk = @TxFullFileName with noformat, noinit, name = @FileName , noskip, stats = 10 , noformat

--출처 : 구글 검색