Raja's Exocortex

Restic Backup of SQL Server and IIS

Using SQLCMD to backup Microsoft SQL Server Express and IIS application.

rem Backup c:\inetpub and SQLEXPRESS DB to e:\backup-repos\inetpub

@echo off
@rem set RESTIC_REPOSITORY="E:\backup-repos\inetpub"
set RESTIC_PASSWORD="secret-pass"

@rem RUN SQLCMD to dump DB to c:\inetpub\sqlbackup\
@rem Backup ESSL dotNet application DB
SqlCmd -E -S WIN-TA8P8F3ECB0\SQLEXPRESS -Q "BACKUP DATABASE [Ess_PunchingData] TO DISK='c:\inetpub\sqlbackup\Ess_PunchingData.bak'"

@rem Backup Fingerprint export
SqlCmd -E -S WIN-TA8P8F3ECB0\SQLEXPRESS -Q "BACKUP DATABASE [Essl] TO DISK='c:\inetpub\sqlbackup\Essl.bak'"

@rem Backup EzyHR DB
SqlCmd -E -S WIN-TA8P8F3ECB0\SQLEXPRESS -Q "BACKUP DATABASE [EzyHr_UPL] TO DISK='c:\inetpub\sqlbackup\EzyHr_UPL.bak'"

@rem "Backup everything except the logs folder
c:\apps\restic -r e:\backup-repos\inetpub --exclude=logs backup c:\inetpub