RESTORE DATABASE isosdb
FROM disk='C:\GeneraliSOS\xhnx\iSOSDB-xhnx20111221\XXX.bak'
with replace,
MOVE 'isosdb_data' to 'C:\GeneraliSOS\xhnx\ISOSDB_DATA.mdf',
MOVE 'isosdb_log' to 'C:\GeneraliSOS\xhnx\ISOSDB_log.ldf'
其中:'C:\GeneraliSOS\xhnx\iSOSDB-xhnx20111221\XXX.bak',表示还原文件。