• The CosmicTrickster (4/15/2012)


    "Now, after you take a log backup, could you see a log file bigger than usual?"

    No points for me. I perceive there being a difference between a "backup file" and a "log file". If someone says "log file" to me, I take it to mean the transaction log file, not the backup.

    I saw could... Could you see a larger backup file.... the correct answer... well it depends... did those bulk activities you forsaw actually occur? Was there a larger amount of normal database traffic that might have caused the log file to grow? Did somebody decide to rebuild all the indexes in the database?

    I mean really... Could that file, or the backup, or whatever have grown? Sure....



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]