Wednesday, March 7, 2012

careless to remove data

I am careless to 'delete from myTable'
any other method to recover the data ?
thanks a lot..If you have not truncate your log, the data should be stay in the log
file and you should be able to restore from the log file.
Agnes wrote:
> I am careless to 'delete from myTable'
> any other method to recover the data ?
> thanks a lot..|||Restore from your most recent backup...
If it just happened and your db is in "Full Recovery" mode, backup the tran
log now
You can then RESTORE with STOPAT to do a point in time recovery
HTH. Ryan
"Agnes" <agnes@.dynamictech.com.hk> wrote in message
news:emI3qwzUGHA.1160@.TK2MSFTNGP09.phx.gbl...
>I am careless to 'delete from myTable'
> any other method to recover the data ?
> thanks a lot..
>|||Hopefully his db wasn't in "Simple" recovery..
HTH. Ryan
<stanleycn@.gmail.com> wrote in message
news:1143642476.867540.66940@.g10g2000cwb.googlegroups.com...
> If you have not truncate your log, the data should be stay in the log
> file and you should be able to restore from the log file.
>
> Agnes wrote:
>

No comments:

Post a Comment