SQL Server Performance

Why transaction logs are misssing ?

Discussion in 'General DBA Questions' started by jay, Jun 22, 2004.

  1. jay New Member

    Hi,

    I am having WIN2K and SQL Server 2000 server.
    The transaction log backup job is schedule after every 15 mins.
    But, If I start the heavy batch upload,the logs are not getting generated.


    Do you have idea about it?

    Thanks,
    jay
  2. satya Moderator

    What is the recovery model set on database?
    If its bulk-logged recovery then using BULK Insert will not generate heavy Tlog.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. jay New Member

    recovery model is set to FULL.
  4. satya Moderator

    What is the size of transaction log backup file?
    Post the query used to upload the batch.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. jay New Member

    The transaction log backup job fires after every 15 min., so the size of tran log varies.

  6. derrickleggett New Member

    If you have the transaction log backups using the same file, it's very possible that your backup job isn't done writing the backups when the next 15 minute interval rolls around. If that's the case, the job won't be able to start again because it's already running. That's my guess about what's happening in your case. Are you using the maintenance plans?

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  7. jay New Member

    yes. I do have the maint. plan.
  8. satya Moderator

    Check the maintenance plan log file for more information on the job steps.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page