명령:EXECUTE master.dbo.xp_create_subdir N''E:\Data\TIM backup & log\TIMDB''
GO
BACKUP DATABASE [TIMDB] TO DISK = N''E:\Data\TIM backup & log\TIMDB\TIMDB_backup_201005070534.bak'' WITH NOFORMAT, NOINIT, NAME = N''TIMDB_backup_20100507053454'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''TIMDB'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''TIMDB'' )
if @backupSetId is null begin raiserror(N''확인하지 못했습니다. 데이터베이스 ''''TIMDB''''에 대한 백업 정보를 찾을 수 없습니다.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''E:\Data\TIM backup & log\TIMDB\TIMDB_backup_201005070534.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
이러한 메세지가 나오는데요 어디가 잘못된건가요 ???ㅜㅜ 도와주세요.... |