↓ Skip to Main Content
Vedran Kesegic Blog
Vedran Kesegic Blog

Main Navigation

  • Home
  • sp_xdetails
  • Performance Logging
Vedran Kesegic Blog
Vedran Kesegic Blog

Off Canvas Menu

  • Home
  • sp_xdetails
  • Performance Logging

Transaction Log

Backup and Recovery, Transaction Log

Transaction Log Backups – How long to keep them?

Vedran Nov 26, 2014

Introduction In this post I will give you a tip on how long it would be …

Transaction Log Backups – How long to keep them? Read more →

Backup and Recovery, Transaction Log

Transaction log myths

Vedran Mar 28, 2013

There are some myths widely spread about transaction log that are to be debunked here: Log …

Transaction log myths Read more →

Backup and Recovery, Transaction Log

Set transaction log size and growth

Vedran Feb 9, 2013

Introduction What is the best practice, how to properly set-up transaction log initial size, growth, and …

Set transaction log size and growth Read more →

Backup and Recovery, Transaction Log

Transaction log Truncate vs Shrink vs VLF number

Vedran Feb 8, 2013

Transaction log truncate – why it didn’t shrink my log ? (Truncate vs Shrink) Introduction One …

Transaction log Truncate vs Shrink vs VLF number Read more →

Backup and Recovery, Transaction Log

Transaction log survival guide: Shrink 100GB log

Vedran Feb 6, 2013

Introduction You got yourself in situation where transaction log has massively grown, disk space became dangerously …

Transaction log survival guide: Shrink 100GB log Read more →

Our Mission

Our Mission

Databases should be fast and simple to use. We make them so. Do not let your customers wait for a slow database response - hire a top professional! We are passionate about creating highly-tuned SQL Server systems. Do you want yours to become one? Simply call us or send email, and we will take care of the rest.

Vedran Kesegić, M.Sc.
SQL Server Database Consultant
Email: [email protected]

A Random Thought

Keep your transaction log backups at least to second full backup. Even if the latest full backup is corrupt, you can recover without any data loss. E.g. if you take full backup weekly, diff backup daily, and transaction log backup hourly, keep your transaction log backup at least for 2 weeks, so it reaches the second full backup.

Categories

  • Backup and Recovery
    • Transaction Log
  • BI
  • Conferences
  • Data Engine
  • Performance
  • Security and encryption
  • Storage
  • TSQL and SQL Client Code
  • Uncategorized

Recent posts

  • Instant SQL Masterpieces
  • Immutable backup against crypto attacks
  • Database recovery IMPORTANT rule
  • SUSPECT database
  • How to partition a really big table?
Copyright © 2026 Vedran Kesegic Blog | Powered by Responsive Theme
Copyright © 2026 Vedran Kesegic Blog | Powered by Responsive Theme
Visit Us On TwitterVisit Us On FacebookCheck Our FeedVisit Us On LinkedinVisit Us On Youtube