Do you check your backups?

Backups. Are you confident you can restore? Do you have a process that ensures you can recover your systems? Learn how one system works in the cloud.

Script - All Jobs (powershell/SMO)

Script powershell/SMO que gera os scripts de DROP/CREATE para cada JOB existente na instância

Configuring Backups Using Veritas Netbackup with AGs

A short description of our experience with Veritas Netbackup on MS SQL Server AG Groups. This article does not give a full description of the procedure for configuring netbackup but highlights a few pitfalls which we think some people will find very useful.

Protecting Encrypted Backups

Backup Encryption Options

Powershell Script for regular DBA activities

This script will perfrom following tasks :
1. BackUp DB
2. Restore DB from BackUp File
3. Restore DB from DB
4. Create a new DB from Existing Db

It takes care of all the possible failures during these operations, while done manually.

AG Backup Preference

Reading Backup History Information for a Database

There are times when you might want to read backup/restore history information to identify a backup’s start and finish date/time, the location where the backup was written, the size of the database backup, etc. Greg Larsen shows you how to do this in SQL Server.

What does Copy-only Backup do?

Verify SQL Backups With SQL Powershell

With SQL Powershell, you can check all your database backups in minutes, whether you have ten SQL servers or 100.