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.
| Author |
Topic |
|
filf
Yak Posting Veteran
67 Posts |
 Posted - 2001-08-23 : 07:08:07
|
| I have a med sized db running on sql 7.0 and I am just wondering what is the correct way/best policy to deal with data deletion from a dB. At the moment I am deleting data outright, but is this such a good thing? This is more a point for discussion than a Q & A thing cos everybody has there own preferences, but I am now realising that deleting outright is really a waste and is also un-recoverable without reverting to backup.What have others used in this situation, would it be better to go with a flag that marks records as Archived/Deleted yet keeps the data in the table, there is no real need to copy deleted data into a new table is there? I am just looking for the wisdom of past experience here so I can implement something that is tried and tested, providing as little redundancy as possible as well as maintaining performance. I look forward to ideas and thoughts. FILF |
|
|
|
|
|
What is a good policy for data deletion?