-- 查看備份文件的類型
RESTORE FILELISTONLY
   FROM DISK = N'D:\DB\AnyImage.bak'

--之后下面寫備份文件的查看到的LocalName和最終要存的路徑
RESTORE DATABASE AnyImage1
FROM DISK=N'D:\DB\AnyImage.bak' 
WITH 
MOVE 'AnyImage_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\AnyImage1.mdf', 
MOVE 'AnyImage_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\AnyImage1_log.ldf',
STATS = 10, REPLACE

GO