'SQL'에 해당되는 글 36건

  1. 2013.03.03 백업과 복원
2013. 3. 3. 12:49


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'



Posted by 펀펀