Funny, I cannot think of a way.. This can be approached... Without like, remove the complete drive, wipe and do a restore.. To a previous time in history that did not contain the DATA.
If you look at the way Oracle 10.2 is .. You have Flashback recovery.. And at any point in time you can recall what was in a table/user/row even.. I guess you have to Wipe all your recoveries too. I know in oracle you can Encrypt the DATA Dynamically to the Drive.. Which would help give you the ability to not Recall it. But .. Huh ... An online Compress will not remove the DATA written to the Drive.. Only move the boundaries of where the data is store.. And this still does not remove the data.. This is Way more complex .. Than it looks.. In the past sites I have been too.. The statement was.. Oh well we lost the days worth of data.. Wipe drive and restore to yesterday and try to import or type in all that data lost.. (Suck it up an deal with it attitude).. Unless the DATA was TOO high and they took your Drive.. And backups. Great Question.. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of L. J. Head Sent: Thursday, April 27, 2006 1:45 PM To: [email protected] Subject: DB Scrub In the DOD arena there are times that data needs to 'disappear'. I was asked by a customer yesterday what options were available for scrubbing of data. I offered the ability to delete records in audit trails and the asked a question I had never even considered. Once Remedy issues the Delete command...and commits the transaction it is deleted out of the table...but what can be done to ensure the data is gone and not just having the pointer to the data removed. Those in government are familiar with the 'military wipe' type of cleaning utilities. We are running SQL Server 2000, are there DB commands that I can run to perform an online compress or something like that? TYIA ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
