Backing up a File for an offline filegroup

Protect SQL Databases with Dell EMC PowerProtect and DataDomain Under VMware

Introduction We are now in the data era – data is growing at rapid space, being processed in different ways, and becoming more distributed across data centers and clouds. Thus databases are also growing and they are stored and protected in various ways depending on business objectives. As more organizations continue to move application and […]

File Backups

Restoring Different Sizes

Backing Up Some Log

Verify your SQL Server database backups

Introduction A popular joke about DBAs and database backups goes like this. There are two types of DBAs: DBAs that do backups DBAs that will do backups The joke is only stating the obvious – lack of database backups might be the end of a DBA career and/or the supported business. Unfortunately, that joke fails […]

Database Backup Types

Getting a List of the Striped Backup Files

If you have a list of striped backup files, how can you find the latest backup set? Steve Jones uses dbatools and PowerShell to automate this process.

Restoring Expired Certificates

Always Check on the Basics

The basics are important, especially with regards to backup and restore in SQL Server.