基本的sql语句:
RESTORE FILELISTONLY
FROM DISK = 'e:\111'--保存的备份文件
-- Restore the files for MyNwind2_Test.
RESTORE DATABASE my
FROM DISK = 'e:\111'
WITH RECOVERY,REPLACE ,
MOVE 'client_acec1_Data' TO 'D:\Program Files\Microsoft SQL Server\MSSQL\Data\my_Data.mdf',
MOVE 'client_acec1_Log' TO 'D:\Program Files\Microsoft SQL Server\MSSQL\Data\my_Log.ldf'