# 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](https://ola.hallengren.com)

The 20240104\_Backup\_ola\_original.sql file is the untouched default version.

[20240104\_Backup\_ola\_original.sql](https://docs.sflservicesllc.com/attachments/1)

<p class="callout warning">Make sure you change the save location of the database, search for @Directory and replace the location.</p>

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](https://docs.sflservicesllc.com/attachments/2)

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](https://docs.sflservicesllc.com/attachments/155)