DatabaseBackupService.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Diagnostics;
using System.IO;
using System.Linq;
using System.ServiceProcess;
using System.Text;
using System.Threading;
using System.Threading.Tasks;

namespace DatabaseBackupService
{
    public partial class DatabaseBackupService : ServiceBase
    {
        private string connectionString;
        private string backupFolder;
        private string logFolder;
        private string databaseName;

        public DatabaseBackupService()
        {
            InitializeComponent();

            //Read configuration values
            connectionString = ConfigurationManager.AppSettings["ConnectionString"];
            backupFolder = ConfigurationManager.AppSettings["BackupFolder"];
            logFolder = ConfigurationManager.AppSettings["LogFolder"];
            databaseName = ConfigurationManager.AppSettings["DatabaseName"];

            databaseName = ConfigurationManager.AppSettings["DatabaseName"];

            if (string.IsNullOrEmpty(databaseName))
            {
                databaseName = "Master"; 
                Log("Database name is missing in App.config, using default: Master");
            }

            if (string.IsNullOrEmpty(backupFolder))
            {
                backupFolder = @"C:\DatabaseBackupService\backupFolder";
                Log("Backup folder is missing in App.config, Using default: " +  backupFolder);
            }

            if(string.IsNullOrEmpty(logFolder))
            {
                logFolder = @"C:\DatabaseBackupService\Logfolder";
                Log("Log Folder is missing in App.config. Using default: " +  logFolder);
            }

            //Ensure directores exist
            Directory.CreateDirectory(backupFolder);
            Directory.CreateDirectory(logFolder);
        }

       
        protected override void OnStart(string[] args)
        {
            Log("Service Sterted");

            PerformBackup(null);
            Log("Backup process completed.");
        }

        protected override void OnStop()
        {
            Log("Service Stoped.");
        }

        private void PerformBackup(object state)
        {
            try
            {
                string backupFileName = Path.Combine(backupFolder, $"{databaseName}_backup_{DateTime.Now:yyyyMMdd_HHmmss}.bak");

                using (SqlConnection connection = new SqlConnection(connectionString))
                {
                    connection.Open();
                    string backupQuery = $@"BACKUP DATABASE [{databaseName}] TO DISK = '{backupFileName}' WITH INIT";

                    using (SqlCommand command = new SqlCommand(backupQuery, connection))
                    {
                        command.ExecuteNonQuery();
                    }
                }

                Log($"Database backup successful for [{databaseName}]: {backupFileName}");
            }
            catch (Exception ex)
            {
                Log($"Error during backup of [{databaseName}]: {ex.Message}");
            }
        }
   

        public void Log(string message)
        {
            string logFilePath = Path.Combine(logFolder, "ServiceLog.txt");
            string logMessage = $"[{DateTime.Now:yyyy-MM-dd HH:mm:ss}] {message}{Environment.NewLine}";

            File.AppendAllText(logFilePath, logMessage);

            //output to console if running in debug mode
            if(Environment.UserInteractive)
            {
                Console.Write(logMessage);
            }
        }

        public void StarInConsole()
        {
            OnStart(null);
            Console.WriteLine("Press Enter to stop the service...");
            Console.ReadLine();
            OnStop();
        }
    }
}