Name: 360-degree Overview of Backup and Restore - Taiob Ali
Start: 2023-08-31T12:00:00-04:00
End: 2023-08-31T14:15:00-04:00

Presentation Title:
360-degree Overview of Backup and Restore

Abstract:
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 by 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'll be able to create a solid Backup and Restore strategy around the agreed service level agreement with your business counterpart.

Learning Objective:
You will get a clear idea about different kinds of basic backups, their dependency on each other, and how to use those backup types. Attendees will also get introduced to an advanced backup-restore strategy. For example, file and filegroup backup, partial database restores, and snapshot backup were introduced in SQL 2022. With this information, you can create a solid backup and restore strategy based on service level agreement.

Free Upcoming Conference
Register: [Future Data Driven 2023 Summit](https://datadrivencommunity.com/FutureDataDriven2023.html#Fddd2023Top)

Jean Joseph

Cloud Data Driven

Azure Data Tech Groups

Technology

Database Professionals

Cloud Computing

Database Development

Data Visualization

Data Mining

Machine Learning

Computer Programming

Big Data

Data Analytics

Cloud Security

Programming Languages

Open Source

Business Intelligence

Data Science

Microsoft MVP - Data Platform
Taiob Ali, Microsoft Data Platform MVP, is an accomplished technical leader with a proven record of success. During his last 17 years, he has worked with the Microsoft Data Platform and MongoDB, both on-premises and cloud. His experience includes all three major business sectors: finance, e-commerce, and healthcare.




Taiob works at “GMO LLC” as a Database Solutions Manager, focusing on cloud migration, automation, improving, and streamlining operational workflow. He regularly speaks at local and international conferences, SQL Saturdays, and Azure conferences. He is a board member of the New England SQL Server User Group, founder of 'Database Professionals Virtual Meetup Group', and organizer of Boston SQL Saturday.

Cloud Data Driven

360-degree Overview of Backup and Restore - Taiob Ali

Cloud Data Driven

Details

Members are also interested in