Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
如何转换 select * from ::fn_dblog(null,null) 查询结果集?
38 views
Skip to first unread message
chentb
Aug 25, 2009, 3:59:40 AM8/25/09
to
��Һ�!
��SQL2005 ���б���ɾ������,��select * from ::fn_dblog(null,null)
where allocUnitName='DATA001' ���Եõ���¼��,
����֪����β���ת���ɿ��ö������� delete from .... ?
��SQL2005 ���б���ɾ������,��select * from ::fn_dblog(null,null)
where allocUnitName='DATA001' ���Եõ���¼��,
����֪����β���ת���ɿ��ö������� delete from .... ?
RM
Aug 29, 2009, 11:57:01 AM8/29/09
to
Use third party tools.
"chentb" wrote:
> 大家好!
> 在SQL2005 里有被误删除的数据,用select * from ::fn_dblog(null,null)
> where allocUnitName='DATA001' 可以得到记录集,
> 但不知道如何才能转换成看得懂的明文 delete from .... ?
>
>
>
dwu
Sep 2, 2009, 9:44:10 PM9/2/09
to
If your transaction log recovery mode is full, you can use third party tool
to trace back every action you took against the sql.
to trace back every action you took against the sql.
http://www.apexsql.com/sql_tools_log.asp
It seems only apexsql log reader is currently still on market. logexplorer
seems not there anymore. Red-gate log rescure is free one, but not too much
help in your case.
--
Hope it helps
dwu
RM
Sep 8, 2009, 9:17:01 AM9/8/09
to
Log Explorer is replaced with Audit DB.
0 new messages