Backup & Restore

Check if a database backup is Full, Differential or Transaction Log Backup

Usually when I’ve create a database backup, I’ll use the backup file name that represent database name, backup type (Full,Differential or Log), and also date and time stamp when that backup created. But what if there is someone else in your team, took that database backup with different name pattern? How do you know if that backup files is… Continue reading Check if a database backup is Full, Differential or Transaction Log Backup

Backup & Restore

My database maintenance tasks and schedule using Olla Hallengren’s script

Every time I’ve installed new SQL Server instance, one of my first task is to create database maintenance plan. Benefits from implementing proper database maintenance plan is to help to prevent or at least to catch early and database problems. First time I know about this SQL Server, I’m using SQL Server Maintenance Plan Wizard… Continue reading My database maintenance tasks and schedule using Olla Hallengren’s script