RESTORE DATABASE [gerber] FROM DISK = N'E:\gerber_backup_200812220200.bak' WITH NORECOVERY, MOVE N'gerber' TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\gerber.mdf', MOVE N'gerber_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\gerber_log.ldf' , NOUNLOAD, REPLACE, STATS = 10
GO
RESTORE database [gerber]
FROM DISK = 'E:\gerber_backup_200812230200.bak' --增量备份的文件
WITH NORECOVERY
RESTORE database [gerber]
FROM DISK = 'E:\gerber_backup_200812240200.bak' --增量备份的文件
WITH RECOVERY
阅读(3976) | 评论(0) | 转发(0) |
