[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Non logged operations

Posted on 2006-05-19
Medium Priority
Last Modified: 2008-01-09

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 ?

Question by:Jan Franek

Accepted Solution

ChrisKing earned 1000 total points
ID: 16722997
I suggest you turn 'select into / blkcopy' off and only turn it on
when you (as a DBA) want to do an unlogged transaction.

This way you will find out who and what when someone
complains "I can't do .. anymore"
LVL 24

Assisted Solution

by:Joe Woodhouse
Joe Woodhouse earned 1000 total points
ID: 16729179
Chris's idea is a pretty good one, you very quickly find things out when you disable stuff! Only problem is, some operations could be done by applications which intercept the Sybase error message and supply their own. It could get tricky to find out what's failing and why.

Another option enabling Sybase auditing. It needs an outage to install, and you definitely shouldn't audit everything as it imposes a large performance penalty, but it's probably the best way to find out who, what and when.

It's possible SQL monitoring through MDA tables (if in a version where they're available) could also do this, but I think that would involve a lot of filtering. With auditing you can specify exactly which events you want to know about...
LVL 14

Author Comment

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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Will the future of mobile app development include the same trends as those most relevant today? Find out by checking out the 7 trends of the future.
Screencast - Getting to Know the Pipeline
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses
Course of the Month19 days, 9 hours left to enroll

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question