您可以创建一个新的数据库，然后使用还原向导"启用覆盖"选项；或者；

You can create a new db then use the "Restore Wizard" enabling the Overwrite option or;

查看内容；

RESTORE FILELISTONLY FROM DISK='c:\your.bak'

请注意.mdf&的逻辑名称然后从结果中找到.ldf；

note the logical names of the .mdf & .ldf from the results, then;

RESTORE DATABASE MyTempCopy FROM DISK='c:\your.bak'
WITH 
   MOVE 'LogicalNameForTheMDF' TO 'c:\MyTempCopy.mdf',
   MOVE 'LogicalNameForTheLDF' TO 'c:\MyTempCopy_log.ldf'

使用内容your.bak创建数据库MyTempCopy.

示例(将名为"creditline"的数据库的备份恢复为"MyTempCopy"；

Example (restores a backup of a db called 'creditline' to 'MyTempCopy';

RESTORE FILELISTONLY FROM DISK='e:\mssql\backup\creditline.bak'

>LogicalName
>--------------
>CreditLine
>CreditLine_log

RESTORE DATABASE MyTempCopy FROM DISK='e:\mssql\backup\creditline.bak'
WITH 
   MOVE 'CreditLine' TO 'e:\mssql\MyTempCopy.mdf',
   MOVE 'CreditLine_log' TO 'e:\mssql\MyTempCopy_log.ldf'

>RESTORE DATABASE successfully processed 186 pages in 0.010 seconds (144.970 MB/sec).