Post reply

SQL Server 2005 transaction Log

  • September 12, 2008 at 8:50 am

    #382629

    Is there a way to look at activities on the transaction log like who and when the initial sizes and

    auto growth parameters were changed on a given database? I looked at the activity logs and

    archived and does not show anything. I'm pretty sure those parameters were changed..

    Ben

  • September 12, 2008 at 10:20 am

    #871131

    I don't think those things are recorded in the transaction log, but you might find something in the default trace log file if it hasn't been too long since the parameters were changed. See "default trace" in BOL.

    Greg

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

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