RESTORE FILELISTONLY
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'

참고 : [http]Restoring .BAK file to a different server?(http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=40841), MSSQL2008/MDF
Retrieved from https://manalith.org:443/wiki/wiki.php/MSSQL2008/BAK
last modified 2010-06-09 14:47:08