|
Home > Archive > MS SQL Server > November 2005 > RE: How to completely delete any trace of data from a SQL2000 data
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
RE: How to completely delete any trace of data from a SQL2000 data
|
|
|
| Didn't have to do anything fancy to do the verification, actually. Using a
text editor robust enough to allow me to view the large data files (I've used
TextPad, UltraEdit 32, and Boxer on various occasions), I did the following:
1. Opened the file.
2. Used the Find function to search for marker text strings I placed in the
document.
3. Found the marker text strings. These were embedded in the full text of
the document, which was present in its entirety.
-B
"Absar Ahmad" wrote:
[color=darkred]
> How are you verifying that ' Text of data file still contains the text of the
> document'?
>
> "BAG" wrote:
>
| |
| Absar Ahmad 2005-11-30, 1:23 pm |
| Are you opening 'data files' of the SQL Server Database?
I am sorry if my question looks stupid.
"BAG" wrote:
[color=darkred]
> Didn't have to do anything fancy to do the verification, actually. Using a
> text editor robust enough to allow me to view the large data files (I've used
> TextPad, UltraEdit 32, and Boxer on various occasions), I did the following:
>
> 1. Opened the file.
> 2. Used the Find function to search for marker text strings I placed in the
> document.
> 3. Found the marker text strings. These were embedded in the full text of
> the document, which was present in its entirety.
>
> -B
>
> "Absar Ahmad" wrote:
>
| |
|
| Exactly. In this case, the DB in question just has one data file (.mdf) and
one log file
(.ldf). I found the text of the document in the .mdf even after I confirmed
it was deleted in the tables.
-B
"Absar Ahmad" wrote:
[color=darkred]
> Are you opening 'data files' of the SQL Server Database?
>
> I am sorry if my question looks stupid.
>
> "BAG" wrote:
>
|
|
|
|
|