MsSQL - Backups

Introduction 

 This is to create auto backups on a SQL server and place them on a drive. 

 Credits go to: 

 Ola Hallengren https://ola.hallengren.com 

 The 20240104_Backup_ola_original.sql file is the untouched default version. 

 20240104_Backup_ola_original.sql 

 Make sure you change the save location of the database, search for @Directory and replace the location. 

 The 20240104_Create_Backups_Integrity_Index_Check.sql is the version used on ESP SQL servers with the use of a DB_Administration table defaults USER dB's to 96 hours and 336 hour for System tables 

 20240104_Create_Backups_Integrity_Index_Check.sql 

 The 20251119_Create_Backups_Integrity_Index_Check.sql is the version used on ESP SQL servers with the use of a DB_Administration table defaults USER dB's to 169 hours and 336 hour for System tables 

 20251119_Create_Backups_Integrity_Index_Check.sql