> I just deleted a bunch of records in error, is there any way to get them > back or have they actually gone (as I suspect)?
Here's your options: 1. Admit they're gone. Re-create the data if possible 2. If you have database backups, restore. Possibly to an alternative server(MSDE) and merge the data with the live database if required. 3. If you have SQL logging enabled(enabled by default), restore from the transaction log. Prepare to cough up some bucks: http://www.red-gate.com/products/sql_log_rescue/index.htm I used the eval of that product to get some of the data out one record at a time, using copy/paste(I think I got around their limitation somehow). I only had to recover a dozen or so records... -- Derek _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
