Thread: Restore
View Single Post
  #10 (permalink)  
Old 07-08-09, 16:51
desireemm desireemm is offline
Registered User
 
Join Date: Feb 2004
Location: Alpine Califormia
Posts: 1,709
ok did a restore with NoRecovery and here is the message I got, looks like the log is too recent to apply to the database.

10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.
100 percent processed.
Processed 21432 pages for database 'AdventureWorks', file 'AdventureWorks_Data' on file 1.
Processed 2 pages for database 'AdventureWorks', file 'AdventureWorks_Log' on file 1.
RESTORE DATABASE successfully processed 21434 pages in 3.333 seconds (52.680 MB/sec).
Msg 4305, Level 16, State 1, Line 3
The log in this backup set begins at LSN 57000000030400034, which is too recent to apply to the database. An earlier log backup that includes LSN 57000000028000001 can be restored.
Msg 3013, Level 16, State 1, Line 3
RESTORE LOG is terminating abnormally.
Reply With Quote