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.
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.
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.
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.
