Post reply

Log files

  • July 19, 2010 at 4:06 am

    #142046

    Hi

    We have a problem on one of our SQL servers, were 2 vendors are making change to a single database. The underline problem is that the Log file for the database grows out of control. The vendors are pointing fingers at each other.

    So my question is, are select transactions recorded in the log files or is it only transactions that alter the database?

    Kind regards

    Bo

  • July 19, 2010 at 4:15 am

    #1194789

    It really depends what the selects do. If a select * from is used, chances are this is not your problem. But if they are running stored procs that create temp tables in the database and then run several big selects to populate and then dump the temp table, chance are that s adding to your headache.

    Consider regular log backups or switch to simple recovery mode (if your business scenario allows this).

    HTH 🙂

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • July 19, 2010 at 4:19 am

    #1194791

    Only data/schema modifications are logged.

    Take a look through this article - http://www.sqlservercentral.com/articles/64582/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 19, 2010 at 4:37 am

    #1194803

    Thank you all for the replies.

  • July 19, 2010 at 12:18 pm

    #1195054

    Only transactions that alter the database like INSERT, DELETE, UPDATE, DROP, CREATE are logged as Gail mentioned.

    Thank You,

    Best Regards,

    SQLBuddy

Viewing 5 posts - 1 through 4 (of 4 total)

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