[SqlCmd] 서버 백업

SqlCmd를 이용한 서버 백업

---

/*

  backup.sql

백업파일은 서버에 저장됨.

*/

DECLARE @PATH NVARCHAR(100)

DECLARE @BACKUPNAME NVARCHAR(100)

SET @PATH =N'D:\BACKUP_' + CONVERT(NVARCHAR(20), GETDATE() ,112)+ N'.BAK'

SET @BACKUPNAME = N'BACKUP_' + CONVERT(NVARCHAR(20), GETDATE() ,112) 

BACKUP DATABASE [카탈로그] TO DISK = @PATH WITH NOFORMAT, NOINIT, NAME = @BACKUPNAME, SKIP, NOREWIND, NOUNLOAD, STATS = 10

GO

---

rem cmd_backup.bat

@echo on

sqlcmd -S [서버명 혹은 IP] -i "backup.sql"

pause

---