declare @strFilename nvarchar(200)
declare @strName nvarchar(200)
set @strName =
N'F:\Backup\MNETMEDIA_BILL_DB\master_backup_' + replace(replace(replace(convert(char(19), getdate(), 120), '-', ''), ':', ''), ' ', '')
set @strFilename =
N'F:\Backup\MNETMEDIA_BILL_DB\master_backup_' + left(replace(replace(replace(convert(char(19), getdate(), 120), '-', ''), ':', ''), ' ', ''), 12) + '.bak'
BACKUP DATABASE
[master] TO
DISK =
@strFilename WITH NOFORMAT, NOINIT, NAME = @strName, SKIP, REWIND, NOUNLOAD, STATS = 10
set @strName =
N'F:\Backup\MNETMEDIA_BILL_DB\model_backup_' + replace(replace(replace(convert(char(19), getdate(), 120), '-', ''), ':', ''), ' ', '')
set @strFilename =
N'F:\Backup\MNETMEDIA_BILL_DB\model_backup_' + left(replace(replace(replace(convert(char(19), getdate(), 120), '-', ''), ':', ''), ' ', ''), 12) + '.bak'
BACKUP DATABASE
[model] TO
DISK =
@strFilename WITH NOFORMAT, NOINIT, NAME = @strName, SKIP, REWIND, NOUNLOAD, STATS = 10
set @strName =
N'F:\Backup\MNETMEDIA_BILL_DB\msdb_backup_' + replace(replace(replace(convert(char(19), getdate(), 120), '-', ''), ':', ''), ' ', '')
set @strFilename =
N'F:\Backup\MNETMEDIA_BILL_DB\msdb_backup_' + left(replace(replace(replace(convert(char(19), getdate(), 120), '-', ''), ':', ''), ' ', ''), 12) + '.bak'
BACKUP DATABASE
[msdb] TO
DISK =
@strFilename WITH NOFORMAT, NOINIT, NAME = @strName, SKIP, REWIND, NOUNLOAD, STATS = 10
'Brain Trainning > DataBase' 카테고리의 다른 글
| 유용한 SQL Poster (0) | 2010.08.26 |
|---|---|
| MSSQL Job(작업) 결과 조회 쿼리 (0) | 2010.08.25 |
| MBSA Command Line Tool (0) | 2010.08.22 |
| MBSA Offline Scan file (0) | 2010.08.22 |
| Understanding How Restore and Recovery of Backups Work in SQL Server 2008 R2 (0) | 2010.08.19 |