백업 방법 'basis' DB를 'c:\db\현재 날자.bak'파일로 백업

c:\> sqlcmd -S localhost -i Backup.sql 

-- << Backup.sql >>--

Declare @name varchar(30)

Declare @dir nvarchar(200)

Declare @backupname nvarchar(100)

Set @name = 'basis'

set @dir = 'c:\DB\' + convert(nvarchar(20), getDate(), 112) + '_' + Replace(CONVERT(varchar(12), GetDate(),108),':','') + '.bak'

set @backupname =     + convert(nvarchar(20), getDate(), 112) + '_' + Replace(CONVERT(varchar(12), GetDate(),108),':','') 

BACKUP DATABASE @name TO DISK = @dir

WITH FORMAT,

MEDIANAME = @backupname,

NAME      = @backupname;

GO