RESTORE FILELISTONLY
FROM DISK = 'D:\db\dbName_backup_201006091230.bak'
FROM DISK = 'D:\db\dbName_backup_201006091230.bak'
위 명령으로 내용을 확인 후 아래와 같이 실행
RESTORE DATABASE dbName
FROM DISK = 'D:\db\dbName_backup_201006091230.bak'
WITH
MOVE 'dbName_Data' TO 'd:\db\dbName.mdf',
MOVE 'dbName_Log' TO 'd:\db\dbName_log.ldf'
FROM DISK = 'D:\db\dbName_backup_201006091230.bak'
WITH
MOVE 'dbName_Data' TO 'd:\db\dbName.mdf',
MOVE 'dbName_Log' TO 'd:\db\dbName_log.ldf'