SQL Server Science
Technical Articles for the DBA / Developer
Home » backup

Self-Hosting Forgejo on Windows Server Hyper-V Step-by-Step

2026-06-01 · by Hannah Vernon · in tools

A complete walkthrough for running Forgejo on Debian 13 inside a Windows Server Hyper-V VM, with Docker Compose, Let’s Encrypt TLS, GitHub repo mirroring, and automated backups to a Windows network share.

Building a Backup Automation Framework with AI

2026-04-23 · by Hannah Vernon · in AI for DBAs

Build a real backup automation framework in PowerShell with AI multi-instance, retention, verification, and dbatools.

Backup Failure and Gap Detection with AI

2026-04-23 · by Hannah Vernon · in AI for DBAs

Catch missed and failed backups before they become an RTO/RPO crisis with AI-built monitoring.

AI-Powered Backup Status Audit Across Your Fleet

2026-04-23 · by Hannah Vernon · in AI for DBAs

Generate a comprehensive backup audit script with AI checking RPO violations, missing backups, and recovery model mismatches.

Storing Backups Locally? You have no Backups!

2019-02-22 · by Hannah Vernon · in recovery

Me, being nice! You’ve got business critical data stored in your SQL Server, don’t you? And you’re taking backups of those databases, right? But where are you storing those backups? If you’re storing backups locally,…

Modify device path for multiple Backup Devices

2019-01-18 · by Hannah Vernon · in maintenance, tools

Backup Devices provide a nice way to permanently configure the backup location, enabling BACKUP DATABASE to look like:

Transact-SQL
1
BACKUP DATABASE [xyz] TO [backup-device-name];

When you create a Backup Device, you specify the physical location where backups will actually be…

1 2 Next »

Search

Categories

  • AI for DBAs
  • announcements
    • events
  • basics
    • localization
  • configuration
  • DMVs
  • documentation
  • extended-events
  • Git for DBAs
  • Hot Takes
  • Internals
  • maintenance
    • patching
  • Opinion
  • performance
  • Professional Development
  • recovery
  • reporting
  • security
    • data security
  • service broker
  • SQL Server Agent
  • statistics
  • sys
  • t-sql
    • xml
  • tools
    • data masking
    • wsus
  • troubleshooting
  • Uncategorized

Pages

  • About SQL Server Science
  • Get Better Help with a Minimal, Complete, and Verifiable Example, or MCVE
  • Privacy Policy

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.

To find out more, including how to control cookies, see here: Cookie Policy

Copyright © 2026 SQL Server Science