Full Backup (1) 썸네일형 리스트형 테이브 백업 및 복구(단순 복구), Transact SQL USE master; --Ensure the database is using the simple recovery model: ALTER DATABASE AdventureWorks SET RECOVERY SIMPLE; GO -- Create a logical backup device for the full AdventureWorks backup. EXEC sp_addumpdevice 'tape', 'DumpTape', '\\.\TAPE0'; GO -- Back up the full AdventureWorks database: BACKUP DATABASE BackupDB TO DumpTape WITH FORMAT, NOUNLOAD; GO --Restore the last of full backup (from.. 이전 1 다음