Search results for query: *

By the way, I solved all this by finding a backup that was not too old, after all. It did not contain all data, of course, but I was able to regain the last couple of transactions simply by parsing the binary MDF file directly. The MDF datafile format is not all that complicated, so it's quite...

Did you try alter database YOUR_DB_NAME set single_user with rollback immediate; in Query Analyzer? /Stefan Lennerbrant

Just an additional note: I notice that the transaction log in question file is actually quite large. May it be so that the transaction log data from the delete operation is actually still available in the transaction log, even though we've performed several backups since then. I though the...

I just detached the database in question and got hold of the MDF file. When attaching it to a local database, the tables are of course (almost) empty. Sigh!:-) However, looking directly into the binary file itself, I can see the data. Fortunately, we've mostly been writing (insert) sequentially...

Well, I suppose the data is not physically deleted, is it? The pages are probably just marked as "free" and it should be possible to recover the data in them, at least in theory. /Stefan Lennerbrant

I unintentionally deleted data from a table with delete from TABLE This was not detected until much later (more than a month ago), and we now have no backup tape that includes the data, just a bunch of empty tables... However, there has not been much writing in the database (not in any...