Link to home
Start Free TrialLog in
Avatar of Jan Franek
Jan FranekFlag for Czechia

asked on

Non logged operations

Hi,

we have set up most of databases for hourly dump of transaction log and weekly database dumps. Transaction dump will try database dump on errors (e.g. when non-logged operation occured). Currently we see lot of unscheduled database dumps, so I believe, that somebody is commiting non-logged operations. Is there a way to find out who and when commited non logged operation on database ?

Jan
ASKER CERTIFIED SOLUTION
Avatar of ChrisKing
ChrisKing

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Joe Woodhouse
Joe Woodhouse

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jan Franek

ASKER

Thanks a lot for ideas. I have turned off "select into / blkcopy" option and I am just working on proper auditing configuration.