Name: The DBA’s Survival Guide: 360° SQL Server Backup and Restore - Taiob Ali
Start: 2025-07-22T12:00:00-04:00
End: 2025-07-22T13:00:00-04:00

If you are the database steward, your most critical task is to guarantee that all committed transactions are always recoverable during a disaster within acceptable limits for data loss and downtimes.

Achieving this can be simple, such as taking a full backup, or complex, which might include filegroup backups based on the size and criticality of your application data.

Whatever your situation is, being well-prepared and practicing with your tools, scripts, and strategy will ensure you can respond quickly and efficiently when a disaster happens.

In this session, I will teach you all the basic types of backups and how to create backups and restores using SSMS and TSQL. Then we will move to advanced techniques, discussing file and filegroup backups, partial database restore, and T-SQL snapshot backups introduced with SQL Server 2022.

At the end of the session, you can create a solid Backup and restore strategy based on the service level agreement you and your business counterpart have agreed to.

**Prerequisites:**

* Basic understanding of SQL Server architecture

* Familiarity with SSMS and T-SQL

**Learning Objectives**:

* Understand and implement various SQL Server backup types—from full and differential to filegroup and snapshot backups.

* Design a disaster recovery strategy tailored to your business SLAs, ensuring minimal downtime and data loss.

DBA Fundamentals

DBA Fundamentals Group

Azure Data Tech Groups

Technology

Database Professionals

SQL Server

Data Management

Database Development

Data Analytics

Microsoft Azure

SQL Azure

Advanced SQL Server

I'm Taiob Ali, a Microsoft Data Platform MVP with over 19 years of experience architecting and managing data solutions across the finance, e-commerce, and healthcare sectors. Currently, I serve as the Database Solutions Manager at GMO LLC, leading a global team across three continents to drive cloud migrations, automation, and operational excellence.​

My expertise spans the Microsoft Data Platform, MongoDB, and emerging technologies like Azure AI and Python for data-driven decision-making. I'm passionate about sharing knowledge and have presented at over 100 events worldwide, including SQL Saturdays, Data Saturdays, and international conferences.​

As a community leader, I founded the Database Professionals Virtual Meetup Group, served on the New England SQL Server User Group board, and organized Boston SQL Saturday. My contributions to Microsoft Learn have been recognized in the Contributor Stories.​

Taiob Ali

The DBA’s Survival Guide: 360° SQL Server Backup and Restore - Taiob Ali 

Online event

Share

DBA Fundamentals Group

The DBA’s Survival Guide: 360° SQL Server Backup and Restore - Taiob Ali

DBA Fundamentals Group

Details

Members are also interested in