Why transaction logs are misssing ? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Why transaction logs are misssing ?

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
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.
recovery model is set to FULL.
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.
The transaction log backup job fires after every 15 min., so the size of tran log varies.
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
[email protected] When life gives you a lemon, fire the DBA.
yes. I do have the maint. plan.
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.
]]>