Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rhankin
Starting Member
5 Posts |
 Posted - 2005-04-21 : 08:02:39
|
| I currently have log shipping turned on for a db. I have had to restore a 2 day old backup over the top of the source db.My Log shipping monitor is now telling me that the destinstion db is out of sync and it is repeatedly trying to restore the same transaction log failing each time:[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4326: [Microsoft][ODBC SQL Server Driver][SQL Server]The log in this backup set terminates at LSN 32042000000397200001, which is too early to apply to the database. A more recent log backup that includes LSN 32093000002424200001 can be restored.[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating abnormally.Is there anyway to recover this without having to re-setup log shipping for this db? |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-04-21 : 11:52:25
|
| Unfortunately i don't think there is.Mike"oh, that monkey is going to pay" |
 |
|
|
|
|
|
Restore db while log shipped