还原数据库脚本

USE master
GO
--RESTORE FILELISTONLY FROM disk = 'E:\Projects\EPMS3\备份\备份_数据库\Epms4'

RESTORE DATABASE Epms4 FROM disk = 'E:\Projects\EPMS3\备份\备份_数据库\Epms4'
WITH RECOVERY,
MOVE 'EPMS4_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL$FUDONG\Data\EPMS4_Data.MDF',  
MOVE 'EPMS4_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL$FUDONG\Data\EPMS4_Log.LDF'
GO