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.

Daily Database Backup Scripts

Execute these stored procedures to backup all your database daily and your transaction logs several time daily. Save space by using the overwrite feature.

DB Integrity & Backup Report

This script returns the date for the most recent log/full backups and checks if a DBCC CHECKDB has ran within a week.

Recent Restore History

This script simply returns the most recent restore information about databases for a server.

Returns the destination database name, the device used to perform the restore and the restore date.