Recover Database Help!

Hello,

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.

ThanksIf you have backups and your db is set to full recovery, you can backup the trans log and issue the restore with StopAt.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_ra-rz_25rm.asp

You could also take a look at third party app, log explorer:
http://www.lumigent.com/products/le_sql.html|||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.