Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2003
    Posts
    2

    Unanswered: Recovering the deleted Table

    Hi,
    I have deleted the table from sql server2000 database by mistake. Is there any way to recover it?It's very urgent.
    Thanks in advance.

  2. #2
    Join Date
    Oct 2002
    Posts
    369

    Re: Recovering the deleted Table

    Q1 I have deleted the table from sql server2000 database by mistake. Is there any way to recover it?It's very urgent.


    A1 Yes.

    1 Restore the most recent DB backup dump to a differently named DB. For example: TestDB

    2 Use a script and an insert statement, or DTS, or a select into statement, etc., to 'copy' (recreate & populate) the table back to the production DB from the TestDB. Depending on the technique used you may need to reapply permissions, constraints, etc., etc..

  3. #3
    Join Date
    Jan 2003
    Posts
    2

    Re: Recovering the deleted Table

    Hi,
    My problem is I don't have the back up of it. Is there any other way say by using the log file or any other?
    Thanx

  4. #4
    Join Date
    Oct 2002
    Posts
    369

    Re: Recovering the deleted Table

    Q1 I don't have the back up of it. Is there any other way say by using the log file or any other?

    A1 If ddl scripts for the table(s) exist somewhere, the dropped tables may be recreated by running them.

    As far as using the log for recovery, the answer is generally no. However, (provided certain conditions are met), a product like log explorer may sometimes be of help in addressing such kinds of situations. {Such products and methods are not a substitute for backup dumps.} See: http://www.lumigent.com/products/le_sql/le_sql.htm

  5. #5
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249

    Re: Recovering the deleted Table

    Data saved to LDF (LOG) files depend on recovery schema used.
    MDF stores current (commited) state of database.
    In full recovery schema, LDF stores all ops after last backup.
    Then LDF can be used to locate changes and MDF can contain
    deleted data.

    That was theory...
    Does anybody know somebody able to display info stored in SQL database binaries ...

  6. #6
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249

    Re: Recovering the deleted Table

    Originally posted by ispaleny
    Does anybody know somebody able to display info stored in SQL database binaries ...
    So DBA does.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •