还原数据库

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

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