Non logged operations

Posted on 2006-05-19
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
    LVL 6

    Accepted Solution

    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
    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

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

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    When we have a dead host and we lose all connections to the ESXi, and we need to find a way to move all VMs from that dead ESXi host.
    Read about the 3 stages of the buyer's journey: awareness, consideration, and decision.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    754 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now