The below is an extract from my presentation at SQL Saturday 252 on high availability and disaster recovery. In this section we talk about the basic process of backing up databases and whether this is enough to meet your requirements.
Read More →Category: SQL Server
Are You High? Can You Recover?
The below is an extract from my presentation at SQL Saturday 252 on high availability and disaster recovery. This post deals with the concepts of RTO and RPO.
Read More →How to Use TSQL to Get Database Backup History
Quick TSQL scripts for finding the dates each database on your server was backed up, or finding the backup chain of a single database.
Read More →How to Use TSQL to Monitor Index Fragmentation
The script I use by default to monitor fragmentation excludes a bunch of indexes I probably don’t care about.
Read More →