Is there any way to recover deleted table data (w. simple log)Hi,
If the recovery model is SIMPLE you can not restore to a POINT_IN_TIME. So
in your case you can not recover directly. The only solution is to restore
the
last full database backup with a new name and copy the table to the real
database.
Thanks
Hari
"NO ROM BASIC" <.> wrote in message
news:OFGFY52CHHA.3660@.TK2MSFTNGP06.phx.gbl...
> Is there any way to recover deleted table data (w. simple log)
>|||Thanks for reply
Ok, but there is no any backup. MDF file contains old data. Is there any
"undelete", "recover deleted" eg. sql commad or utility?
Possible a utilty for extract deleted sql row or table data because delete
function not really delete this data. I find a util, view mdf file
structure, pages and some info this pages but this insufficient to restore.
Thanks
"Hari Prasad" <hari_prasad_k@.hotmail.com>, haber iletisinde þunlarý
yazdý:%23vT98y6CHHA.4992@.TK2MSFTNGP03.phx.gbl...
> Hi,
> If the recovery model is SIMPLE you can not restore to a POINT_IN_TIME. So
> in your case you can not recover directly. The only solution is to restore
> the
> last full database backup with a new name and copy the table to the real
> database.
> Thanks
> Hari
>
> "NO ROM BASIC" <.> wrote in message
> news:OFGFY52CHHA.3660@.TK2MSFTNGP06.phx.gbl...
>> Is there any way to recover deleted table data (w. simple log)
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment