10-10.sql

来自「SQL2000跟课件学习的源代码 分享共同学习」· SQL 代码 · 共 9 行

RESTORE DATABASE Educational FROM DISKBackup_Edu
WITH NORECOVERY  /* 先还原完整数据库备份,需指定NORECOVERY */
RESTORE DATABASE Educational FROM DISKBackup_Edu
WITH FILE = 2, NORECOVERY		/* 在还原完整数据库备份的基础上,还原差异备份 */
RESTORE LOG Educational FROM DISK ='E:\Backups\Edu\Backup_Edu_Log.bak'
WITH PASSWORD='MyPass', NORECOVERY  /* 还原第一次事务日志备份 */
RESTORE LOG Educational FROM DISK ='E:\Backups\Edu\Backup_Edu_Log.bak'
WITH FILE = 2, RECOVERY		/* 还原第二次事务日志备份*/