Action tracking

Hi,
We have a table that holds thousands of data in SQL server. However, the
data is suddently gone yesterday. I am just wondering if there is a way to
check when and how (who did) the data is gone. Can we track the action from
log files or somewhere?
Thanks in advance!if you have the database at FULL recovery, download a trial version of Log
Explorer at lumigent.com. It will tell you who's who?
"Jean" <Jean@.discussions.microsoft.com> wrote in message
news:86B01DE6-8302-4C6D-9D63-8FFF7D24AB74@.microsoft.com...
> Hi,
> We have a table that holds thousands of data in SQL server. However, the
> data is suddently gone yesterday. I am just wondering if there is a way to
> check when and how (who did) the data is gone. Can we track the action
> from
> log files or somewhere?
> Thanks in advance!|||Unfortunately, our database is Simple for recovery model. Is there any other
way to find it?
Thanks again!
"ME" wrote:
> if you have the database at FULL recovery, download a trial version of Log
> Explorer at lumigent.com. It will tell you who's who?
> "Jean" <Jean@.discussions.microsoft.com> wrote in message
> news:86B01DE6-8302-4C6D-9D63-8FFF7D24AB74@.microsoft.com...
> > Hi,
> >
> > We have a table that holds thousands of data in SQL server. However, the
> > data is suddently gone yesterday. I am just wondering if there is a way to
> > check when and how (who did) the data is gone. Can we track the action
> > from
> > log files or somewhere?
> >
> > Thanks in advance!
>
>|||Unless you are either running a trace, have c2 auditing,
have some trigger mechanism to sort who did what and when,
or have the utility ME sugested then no.
If I were you I would really see about tightening up
security as you either have a hacker or an inexperienced
user / developer.
Do you have back ups ?
Peter
"Happiness is having a large, loving, caring, close-knit
family in another city."
George Burns
>--Original Message--
>Hi,
>We have a table that holds thousands of data in SQL
server. However, the
>data is suddently gone yesterday. I am just wondering if
there is a way to
>check when and how (who did) the data is gone. Can we
track the action from
>log files or somewhere?
>Thanks in advance!
>.
>|||:-(
why was it set at SIMPLE recovery if you need that much?
"Jean" <Jean@.discussions.microsoft.com> wrote in message
news:A7AD9D50-59E2-4B15-A03A-2399645BCC2E@.microsoft.com...
> Unfortunately, our database is Simple for recovery model. Is there any
> other
> way to find it?
> Thanks again!
> "ME" wrote:
>> if you have the database at FULL recovery, download a trial version of
>> Log
>> Explorer at lumigent.com. It will tell you who's who?
>> "Jean" <Jean@.discussions.microsoft.com> wrote in message
>> news:86B01DE6-8302-4C6D-9D63-8FFF7D24AB74@.microsoft.com...
>> > Hi,
>> >
>> > We have a table that holds thousands of data in SQL server. However,
>> > the
>> > data is suddently gone yesterday. I am just wondering if there is a way
>> > to
>> > check when and how (who did) the data is gone. Can we track the action
>> > from
>> > log files or somewhere?
>> >
>> > Thanks in advance!
>>