Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to Recover Database, out of ideas 1

Status
Not open for further replies.

Ralph8

IS-IT--Management
Mar 15, 2003
168
US
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
 
Are you trying to export the whole DB in one DTS push? If so, you may have to DTS each table. 10 to 1, one of the tables is corrupt and is causing this event.

Thanks

J. Kusch
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top