先查看数据库逻辑名称:
restore filelistonly from disk='D:/database.bak'
然后恢复:
restore database smsdb from disk = 'd:smsdb.bak' with move '数据库逻辑名称' to 'C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLDATAdb_data.mdf' ,move '日志逻辑名称' to 'C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLDATAdb_log.ldf'