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.

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.

Backup All User Databases

Backup all user databases on a SQL Server instance.

Complete Details About Backups Taken a Day Ago

Complete Details About Backups Taken a Day Ago.

Taking Backup Of All DBs

Wrote the script to take compressed backup with combining many other features.

Delete Backups Older than N Days

SCRIPT TO DELETE OLDER THAN N' DAYS BACKUP FROM A DEFAULT BACKUP DIRECTORY. IF DAYS = 0, PROVIDED,
IT WILL DELETE ALL BACKUP FILES FROM THE BACKUP LOCATION.

Stop Relying on Cloud File Stores as a Backup Strategy

There is a growing assumption that Cloud file-storage services represent an ideal way of backing up files. It seems a compelling idea because it is so easy and seems secure. The truth is, as always, more complicated. There is more to any backup strategy than just cloud storage.