"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\sqlcmd" -S localhost -i e:\Backup\backup.sql

declare @runtime nvarchar(10)
declare @backupdevice nvarchar(100)
declare @backupname nvarchar(100)

set @runtime = substring(convert(nvarchar(20), getdate(), 8) ,1,2)
set @backupdevice = N'e:\Backup\backup_' +  @runtime  + N'.bak'
set @backupname = N'backup_' +  @runtime

BACKUP DATABASE [TU] TO  DISK = @backupdevice WITH NOFORMAT, INIT,  NAME = @backupname, SKIP, NOREWIND, NOUNLOAD,  STATS = 10

declare @runtime nvarchar(10)
declare @backupdevice nvarchar(100)
declare @backupname nvarchar(100)

set @runtime = substring(convert(nvarchar(20), getdate(), 8) ,1,2)
set @backupdevice = N'e:\Backup\backup_' +  @runtime  + N'.bak'
set @backupname = N'backup_' +  @runtime

BACKUP DATABASE [TU] TO  DISK = @backupdevice WITH DIFFERENTIAL, NOFORMAT, INIT,  NAME = @backupname, SKIP, NOREWIND, NOUNLOAD,  STATS = 10

크리에이티브 커먼즈 라이센스

이 저작물은 크리에이티브 커먼즈 코리아 저작자표시-비영리-변경금지 2.0 대한민국 라이센스에 따라 이용하실 수 있습니다.

(0) (0)