Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Recovery

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-09-16 : 08:35:38
Mehmet writes "How do I recover cascade deleted records from MSSQL 2000 ?
no backup"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2004-09-16 : 08:37:06
Buy Log Explorer from Lumigent:

http://www.lumigent.com/

Or re-enter them by hand. I think you'll agree you should change those constraints to NOT cascade anymore (updates and deletes)
Go to Top of Page

MuadDBA

628 Posts

Posted - 2004-09-16 : 10:51:50
And maybe you want to start thinking about regular backups, too.
Go to Top of Page
   

- Advertisement -