I have been trying to recover a SQL Server 7 DB for days now.
I have two copies of the .mdf and .ldf files that I saved about a week apart. My development work was going unusually smoothly during that week with no apparent problems.
When I decided I needed to "back off" to a previous copy of the Dev DB none of the substitute and re attach techniques that I learned from you guys worked this time. I always got a message that a invalid LSN is being passed. Got the same message with both copies of the DB.
I tried the techniques in FAQ962-4210 as that has "saved my bacon" a couple of times. That appears to go well as the DTS package executes but at the end I get a message that "One task failed" with no clue as to what that task was. The receiving DB always turns up empty. I have tried every variation that I can think of but I always ge the same result.
Any ideas out there?
TIA
Ralph D. Meredith
I have two copies of the .mdf and .ldf files that I saved about a week apart. My development work was going unusually smoothly during that week with no apparent problems.
When I decided I needed to "back off" to a previous copy of the Dev DB none of the substitute and re attach techniques that I learned from you guys worked this time. I always got a message that a invalid LSN is being passed. Got the same message with both copies of the DB.
I tried the techniques in FAQ962-4210 as that has "saved my bacon" a couple of times. That appears to go well as the DTS package executes but at the end I get a message that "One task failed" with no clue as to what that task was. The receiving DB always turns up empty. I have tried every variation that I can think of but I always ge the same result.
Any ideas out there?
TIA
Ralph D. Meredith