Part 1 -- Restore a database to another instance...

A great script that I wrote some time ago to allow the last database backup to be restored across a linked server to another server, after running a remote sproc on the destination to kill off any users on the receiving side.

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.

Restore

Why PolyBase matters - Part 2

Part 2, a more in depth look at An alternative approach to disaster recovery and backup strategies using PolyBase.

Why PolyBase Matters

An alternative approach to disaster recovery and backup strategies using PolyBase.

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.

Delete Backup Files From Default Backup Location

IF you have need to schedule job to cleanup backup files older than N days, you can use my written script.

Copy Backup Files to Remote Shared Location and Delete them periodically

If you have a requirement where you need to copy all your backup files to any remote shared location from your local folder/drive and after that you need to do a periodic cleanup of the backup files, you can use my script.

The MidnightDBAs release Minion Backup

The MidnightDBA team is announcing the release of a new, free backup solution for SQL Server: Minion Backup. We created Minion Backup (or MB, for short) to be the most flexible, feature-rich backup solution possible.