Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Location
    San Francisco, CA
    Posts
    506

    Unanswered: How to restore the deleted records?

    Hi,
    Plz help me to restore deleted records.Pl zsuggest the ways to do it.
    Thanks!!
    Success is the ability to go from one failure to another with no loss of enthusiasm.
    - Sir Winston Churchill
    Joydeep

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    There's no way within the SQL Server product itself. Rows aren't "flagged for deletion" like they are in some products (which isn't strictly true, but close enough for this discussion). Once SQL deletes them, they are truly gone.

    There are some third party products that mitigate this, such as Lumigent's Log Explorer.

    -PatP

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Or restore the data from last good known backup
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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