🗄️ Database Backup Service

Automated Windows Service for performing scheduled full backups of a SQL Server database.

---

📌 Overview

• Performs full database backups using SQL Server
• Executes backup via stored procedure
• Runs on a configurable time interval
• Saves backup files to a backup folder
• Logs all operations to a log folder
• Supports console mode for debugging
• Configurable via App.config

---

📝 Requirements

• Windows 10 / 11 or Server editions
• .NET Framework 4.7+
• SQL Server (Local or Remote)
• Admin privileges to create/manage Windows Service
• Service account with write access to backup and log folders

---

⚙ Configuration (App.config)

<appSettings>
  <add key="ConnectionString" value="Server=YOUR_SERVER;Database=YOUR_DATABASE;Trusted_Connection=True;" />
  <add key="BackupFolder" value="C:\DatabaseBackups\" />
  <add key="LogFolder" value="C:\DatabaseBackups\Logs\" />
  <add key="BackupIntervalMinutes" value="1" />
</appSettings>

🚀 Installation & Commands

Create Service

sc create DatabaseBackUpService binPath= "C:\Path\To\DatabaseBackUpService.exe" start= auto

Start Service

sc start DatabaseBackUpService

Stop Service

sc stop DatabaseBackUpService

Delete Service

sc delete DatabaseBackUpService

📄 Logging

Sample output:

[2026-01-16 16:00:00] Service Started.
[2026-01-16 16:00:01] Backup schedule Initiated: every 1 minute(s).
[2026-01-16 16:01:01] Database Backup Created Successfully C:\DatabaseBackups\Backup_20260116_160101.bak
[2026-01-16 16:02:01] Database Backup Created Successfully C:\DatabaseBackups\Backup_20260116_160201.bak
[2026-01-16 16:03:01] Database Backup Created Successfully C:\DatabaseBackups\Backup_20260116_160301.bak
[2026-01-16 16:04:01] Database Backup Created Successfully C:\DatabaseBackups\Backup_20260116_160401.bak
[2026-01-16 16:05:00] Service Stopped.

🗃️ Backup Details

File naming format:

Backup_yyyyMMdd_HHmmss.bak