Restoring SQL Server Data

hi. I just ran a dts that overwrote my data in my sql server 2000 database. Is it possible to still recover my old data?if you are running in full backup mode and you just ran DML statements, backup the transaction log of the database and restore the whole backup (full + evtl. differential + transaction log) with the option point -in-time recovery, stopping the restore until a specific time. if you don′t have the full backup model or no full backup, then there is no chance.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

I agree with the above answer, but if you have not been taking backups you will not be able to recover the database.

sql