RESTORE DATABASE [review2] FROM DISK = N'E:\SQLDATA\Review20081117.bak' WITH NORECOVERY, MOVE N'Review' TO N'd:\sqldata\review\review2.mdf', MOVE N'Review_log' TO N'd:\sqldata\review\review2_log.ldf' , NOUNLOAD, REPLACE, STATS = 10
GO
RESTORE LOG [review2]
FROM DISK = 'E:\SQLDATA\Review2008111820.trn'
WITH NORECOVERY
RESTORE LOG [review2]
FROM DISK = 'E:\SQLDATA\Review2008111920.trn'
WITH NORECOVERY
RESTORE LOG [review2]
FROM DISK ='E:\SQLDATA\Review2008112020.trn'
WITH NORECOVERY
RESTORE LOG [review2]
FROM DISK ='E:\SQLDATA\Review2008112120.trn'
WITH RECOVERY
RESTORE LOG [review2]
FROM DISK ='E:\SQLDATA\Review2008112220.trn'
WITH NORECOVERY
RESTORE LOG [review2]
FROM DISK ='E:\SQLDATA\Review2008112320.trn'
WITH RECOVERY
阅读(2384) | 评论(0) | 转发(0) |