[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 = 10GO rem cmd_backup.bat@echo on..
더보기