RE

  • ACCIDENTLY THE RECORDS IN THE DATABASE TABLE WAS DELETED IN SQL SERVER 2000 IS THERE ANY CHANCE OF RECOVERING THE SAME PLEASE.

  • backup the tail of the log and do a point in time resotre of your full backups and t-log backups prior to the point of the deletion

  • If you have a backup from before the delete, yes. If you don't, no.

    p.s. Please don't type in all caps. It's the online equivalent of shouting.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply