Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2005

    Red face Unanswered: Recover Database Help!


    Is it possible to restore a SQL 2000 database with data from a transaction log?

    I am not sure what happened to my database, all the data in the tables is gone. I generated a db script to create a duplicate database. I saved the .sql file on my local machine, separate from the db server, renamed the database name in the .sql file to a new database. Tested script in query analyzer for syntax, all was fine. Running it at this point would have created a new database with a different name, right?

    Now my original database is empty. Can someone please provide me with information on getting my data back. Is there a way of using the transaction log to recover the data.


  2. #2
    Join Date
    May 2002
    If you have backups and your db is set to full recovery, you can backup the trans log and issue the restore with StopAt.

    You could also take a look at third party app, log explorer:

  3. #3
    Join Date
    Jan 2003
    Provided Answers: 11
    In order to use the native SQL Server backups, you need to start from a full backup, which makes sense, since it is the only way to have a point to roll transactions forward from.

Posting Permissions

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