↓ 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

Backup and Recovery

Backup and Recovery, Security and encryption

Immutable backup against crypto attacks

Vedran Oct 9, 2025 Tagged with Backup, Cryptovirus, Security

Have you heard about Retention lock, Immutable Shared Folder, WORM (Write Once Read Many)? Many NAS …

Immutable backup against crypto attacks Read more →

Backup and Recovery

Database recovery IMPORTANT rule

Vedran Jul 28, 2024

Recently, I had a case with a customer in a really difficult situation. They accidentally deleted …

Database recovery IMPORTANT rule Read more →

Backup and Recovery

SUSPECT database

Vedran Jun 14, 2024 Tagged with RESTORE, SUSPECT

Recently I had a customer case with a “suspect” database. In that state database is not …

SUSPECT database Read more →

Crypto-virus resistent backup
Funny hacker in action on his keyboard
Backup and Recovery

Crypto-virus resistent backup

Vedran Jun 24, 2017 Tagged with Backup, Cryptovirus, FreeFileSync, Ransomware, Security, Veeam Endpoint Backup

Introduction Crypto-viruses encrypt your data. If it asks money (a ransom) to decrypt, we call them …

Crypto-virus resistent backup Read more →

Backup and Recovery

Database Recovery from RAM

Vedran Nov 6, 2016

Introduction Recently I had a client who basically lost his SQL Server databases. I decided to …

Database Recovery from RAM Read more →

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

Disk failure probability on a large number of disks

Vedran Aug 8, 2013

Introduction We either have or will experience a drive failure. Doesn’t matter if we talk about …

Disk failure probability on a large number of disks 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 →

Posts pagination

1 2 Next

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

You don't have a backup until you tried to restore it! Validate your backups. At least, use RESTORE VERIFYONLY immediately after a backup, and use CHECKSUM option when doing a 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