SQL Server 2000 Rollback?

[Jason Scott Smi]

I've accidentally (of course) overwritten all Intranet database tables
in production with those in dev using DTS. I'm meant to only copy over
new tables but somehow got everything instead. Server guys said backups
weren't running for some reason. Is there anyway I can revert this
database back to earlier in the day?
--
Posted via http://dbforums.com

[Simon Hayes]

"Jason Scott Smi" <me*********@dbforums.com> wrote in message
news:34****************@dbforums.com...

I've accidentally (of course) overwritten all Intranet database tables
in production with those in dev using DTS. I'm meant to only copy over
new tables but somehow got everything instead. Server guys said backups
weren't running for some reason. Is there anyway I can revert this
database back to earlier in the day?
--
Posted via http://dbforums.com

If your database is in full recovery mode, then you should be able to backup
the transaction log, restore the last available full backup, then restore
the log backup(s) to a point in time before you overwrote your tables. See
"Recovering to a point in time" in Books Online.

But if you don't have a log backup, and the log has been truncated or the
database is in Simple reovery mode, then there probably isn't a lot you can
do.

Simon

[Erland Sommarskog]

Jason Scott Smi (me*********@dbforums.com) writes:

I've accidentally (of course) overwritten all Intranet database tables
in production with those in dev using DTS. I'm meant to only copy over
new tables but somehow got everything instead. Server guys said backups
weren't running for some reason. Is there anyway I can revert this
database back to earlier in the day?

If the database is running in full recovery mode, you might be able
to save the day with the 3rd party tool Lumigent Log Explorer,
http://www.lumigent.com.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp