Restore deleted rows

25 Aug 2006 9:09 PM

Mark Goldin

Is it possible to restore deleted rows?

Thanks

25 Aug 2006 9:19 PM

--CELKO--

>> Is it possible to restore deleted rows? <<

Look up ROLLBACK in Books on Line. Then look up how to use the log to
restore the database, if you did not rollback in time.

25 Aug 2006 9:22 PM

Arnie Rowland

Most administrators, eventually, find a need for a third party log tool,
such as PI Log Explorer, ApexSQL's Log, Lumingent's Log Explorer. Most the
these tools will allow you to recover data that 'should' not have been
deleted.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

Show quote

"Mark Goldin" <mgol***@ufandd.com> wrote in message
news:OLcu2qIyGHA.4524@TK2MSFTNGP04.phx.gbl...
> Is it possible to restore deleted rows?
>
> Thanks
>

26 Aug 2006 2:07 AM

Hari Prasad

Hi,

Take a look into POINT IN TIME recovery in books online

Thanks
Hari
SQL Server MVP

Show quote

"Arnie Rowland" <ar***@1568.com> wrote in message
news:eufPlyIyGHA.3656@TK2MSFTNGP04.phx.gbl...
> Most administrators, eventually, find a need for a third party log tool,
> such as PI Log Explorer, ApexSQL's Log, Lumingent's Log Explorer. Most the
> these tools will allow you to recover data that 'should' not have been
> deleted.
>
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
>
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
>
> "Mark Goldin" <mgol***@ufandd.com> wrote in message
> news:OLcu2qIyGHA.4524@TK2MSFTNGP04.phx.gbl...
>> Is it possible to restore deleted rows?
>>
>> Thanks
>>
>
>