还原数据库

RESTORE DATABASE [ERP]
FROM DISK = N'D:\ZBFERP_FULL_2016-11.bak'
WITH FILE = 1,
MOVE N'FERP_DB' TO N'D:\DATABASE\ERP.mdf',
MOVE N'FERP_DB_log' TO N'D:\DATABASE\ERP_1.ldf',
NORECOVERY, NOUNLOAD, STATS = 10
GO

RESTORE DATABASE [ERP]
FROM DISK = N'D:\ZBFERP_DIFF_2016-11-16.bak'
WITH FILE = 1,
MOVE N'FERP_DB' TO N'D:\DATABASE\ERP.mdf',
MOVE N'FERP_DB_log' TO N'D:\DATABASE\ERP.ldf',
RECOVERY, NOUNLOAD,
REPLACE, STATS = 10
GO