백업과 복원

backup database INNOYADB to disk = 'c:\INNOYADB.bak'

RESTORE FILELISTONLY FROM DISK = 'c:\INNOYADB.bak'

RESTORE DATABASE INNOYADB_BACKUP FROM DISK = 'c:\INNOYADB.bak'
WITH REPLACE
, MOVE 'INNOYADB' TO 'c:\[0]Sql_Data\INNOYADB_BACKUP.mdf'
, MOVE 'INNOYADB_log' TO 'c:\[0]Sql_Data\INNOYADB_BACKUP_log.ldf'