Expert Guidance Required for SQL…?

Discussion in 'Databases' started by datasolution, Jul 31, 2007.

0
  1. #1
    Expert Guidance Required for SQL…?

    How I can recover my deleted record in ms sql server 2000 from log files, if I delete a record in sql query analyzer without using begin transaction. Can I open to see log file? What is filename & extension of log file and location...?


    Thanks in Advance...
    :)
     
    datasolution, Jul 31, 2007 IP
  2. Kommunicate

    Kommunicate Peon

    Messages:
    60
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Assuming your transactions were being logged and you haven't truncated your log, you should be able to recover from the point in time right before you ran your statement in the Query Analyzer.

    The steps are kind of involved and would take a long time to describe here. There's a good article on how to use SQL Server Enterprise Manager to recover your transactions here:

    http://www.databasejournal.com/features/mssql/article.php/3530616​

    You can also Google "Sql Server 2000 Point in Time Recovery"

    Hope this helps. Good luck.
     
    Kommunicate, Aug 2, 2007 IP
  3. datasolution

    datasolution Banned

    Messages:
    60
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Thanks Kommunicate....
    its really helpful....:)
     
    datasolution, Aug 9, 2007 IP