Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: Revover MS SQL 2000 from Log file (last 4 hours)

    Sorry in advance for the stupid question but I am not a technical expert at all!!!

    I made a backup from a SQL-Server 2000 DB 3 days ago. Today data have been deleted from the system and they should be recovered. I have a full recovery model.

    I tried to restore the DB but before I made a new backup (Just in case) I hope that was no error????

    Is there a way to restore the DB from the log file but just restore the last 4 hours?


  2. #2
    Join Date
    Aug 2002
    If you maintain Tlog backups and rEview information on books online about restoring Tlogs upto a point of time.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

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