audit database options change

  • We ran into a rather bizarre situation. On one of our database instances somebody changed two log shipping databases from Full backup to simple backup. This caused log shipping to break. We have no idea who or why the person did this. Following this we tightened security and changed passwords but I still would like to know who did it and why. Any thoughts on how to figure out who was the culprit.

    thanks

    David

  • The default trace should contain a row for that change.

    This should show you where the trace file is located:

    SELECT *

    FROM sys.traces

    -- Gianluca Sartori

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply