Re: Data Loss?
From: Simon Shearn (simon_at_antispam.aardvarks)
Date: 12/07/04
- Next message: Russell Fields: "Re: blocking caused from SQL with (nolock) hint"
- Previous message: Stephen Dybing [MSFT]: "Re: open up .mdf and .ldf file types"
- In reply to: Dan B: "Data Loss?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 7 Dec 2004 20:16:22 -0000
"Dan B" <none@none.com> wrote in message
news:u038qvI3EHA.2012@TK2MSFTNGP15.phx.gbl...
> Hi,
> I'm sure this is a very broad question, but what could cause roughly
> 125,000 rows in one table to disappear over night. I'm running SQL server
> 7. I've done multiple virus scans....all clean....although mydoom was
> previously found and quarantined.
>
> Could someone give me at least a starting point on troubleshooting this.
> The same thing happened to the same table about 3 months ago. At that
time,
> I figured it was some strange fluke, but now that it has happened again,
it
> is rather disconcerting.
>
> Any help would be appreciated!!
>
> Thanks,
> Dan
>
Perhaps you could add a trigger to the table that would write diagnostic
information to a logging table, such as time-of-deletion and possibly
information about the user that the deletion SQL was running as.
Regards,
Simon
- Next message: Russell Fields: "Re: blocking caused from SQL with (nolock) hint"
- Previous message: Stephen Dybing [MSFT]: "Re: open up .mdf and .ldf file types"
- In reply to: Dan B: "Data Loss?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
