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!

Search results for query: *

  1. stefanlennerbrant

    Recover rows from table, unintentionally deleted

    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...
  2. stefanlennerbrant

    Can't change DB to single user

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

    Recover rows from table, unintentionally deleted

    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...
  4. stefanlennerbrant

    Recover rows from table, unintentionally deleted

    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...
  5. stefanlennerbrant

    Recover rows from table, unintentionally deleted

    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
  6. stefanlennerbrant

    Recover rows from table, unintentionally deleted

    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...

Part and Inventory Search

Back
Top