skills.rest
rudi-bruchez
rudi-bruchezCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

sqlserver-backup-recovery

Design SQL Server backup schedules and perform point-in-time restores with T-SQL scripts.

Updated Feb 19, 2026
Search Tags:#restore#backup#recovery#sql server#database administration#point-in-time
One-click install
npx skills add https://github.com/rudi-bruchez/dba-skills --skill sqlserver-backup-recovery
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqlserver-backup-recovery
Source: https://github.com/rudi-bruchez/dba-skills/tree/main/skills/sqlserver-backup-recovery
Command: npx skills add https://github.com/rudi-bruchez/dba-skills --skill sqlserver-backup-recovery

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill provides comprehensive guidance and T-SQL scripts for designing robust SQL Server backup strategies and executing various restore operations, ensuring data safety and rapid recovery.

Core Features & Use Cases

  • Backup Strategy Design: Tailor backup schedules (Full, Differential, Log) to meet RPO/RTO requirements.
  • Restore Operations: Perform full, point-in-time, and cross-server restores with detailed step-by-step instructions.
  • Verification & Monitoring: Implement backup verification and utilize monitoring queries to ensure backup integrity and detect failures.
  • Use Case: Recover a critical database to a specific point in time just before an accidental data deletion occurred, minimizing data loss.

Quick Start

Use the sqlserver-backup-recovery skill to restore the database 'YourDB' from a full backup file located at 'D:\Backups\YourDB_Full_20240115.bak'.

Frequently Asked Questions about sqlserver-backup-recovery

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I perform a point-in-time restore in SQL Server?▼

A point-in-time restore in SQL Server recovers a database to a specific moment using a sequence of full, differential, and log backups. This Skill provides T-SQL scripts to automate the process and minimize data loss.

What is the best way to design a SQL Server backup strategy for RPO and RTO?▼

Designing a SQL Server backup strategy involves tailoring full, differential, and log backup schedules to meet your specific Recovery Point Objective and Recovery Time Objective requirements. This Skill offers guidance to structure these automated schedules effectively.

Does this SQL Server backup and recovery skill support older versions like SQL Server 2014?▼

This SQL Server backup and recovery skill supports SQL Server 2016 and later versions. It provides automated T-SQL scripts and monitoring queries specifically designed for these more recent database administration environments.

How can I verify SQL Server backup integrity and monitor for failures?▼

Verifying SQL Server backup integrity involves running validation checks and monitoring queries to detect failures. This Skill includes T-SQL scripts to ensure your backups are structurally sound and reliably restorable when needed.

Can I restore a SQL Server database to a different server using T-SQL scripts?▼

Yes, you can execute cross-server restores to recover a database on a different SQL Server instance. This Skill provides step-by-step instructions and T-SQL scripts to manage full and point-in-time recovery operations across servers.

Related Skills

Explore More Software Engineering Skills→
rudi-bruchezrudi-bruchez

sqlserver-high-availability

Manage and monitor SQL Server high availability and disaster recovery solutions.

Community
Advanced
Prompt-or-Die-LabsPrompt-or-Die-Labs
7

disaster-recovery-planner

Design disaster recovery strategies with tiered RTO/RPO targets and multi-region DNS failover.

Official
Intermediate
larsnyglarsnyg

sql-server-admin

Automate SQL Server administration tasks including backups, security, and maintenance.

Community
Advanced
davidrrowleydavidrrowley

azure-resource-manager-mysql-dotnet

Automate Azure MySQL Flexible Server management using the .NET SDK.

Community
Advanced