MS SQL Server :: English: SQL Backups & Restores

Would you like to hire me for your SQL questions and solutions? Fiverr: https://www.fiverr.com/s/e6ALv5E UpWork: https://www.upwork.com/freelancers/~018d4b13887d9d50c6?mp_source=share I've worked across SQL Server, MySQL, and PostgreSQL, supporting both small businesses and enterprise-level environments. Whether it's a one-time fix or ongoing support, I'll bring clarity, reliability, and efficiency to your data. Your database problems don't have to slow you down, let's solve them together! Github files: https://github.com/WallyPons/YouTube 1. BackupProcess.sql Chapters: 00:00 Intro 00:31 Slide - What is a Backup? 02:39 Slide - Database Types 05:04 Slide - Recovery Model Types 06:19 T-SQL: Backup Script Explained 13:28 T-SQL: Execute Backup Scripts 13:42 SSMS: Backup a Database 19:33 T-SQL: RESTORE LABELONLY 21:48 T-SQL: RESTORE HEADERONLY 32:59 T-SQL: RESTORE FILELISTONLY 36:33 T-SQL: RESTORE VERIFYONLY 37:01 T-SQL: Backups: Before Automation 38:28 T-SQL: Automated Backups Script 44:36 Verify SQL Services and Backup Folder Path 45:50 SSMS: Create SQL Job: Full Backup 49:13 SSMS: Create SQL Job: Diff Backup 52:46 SSMS: Create SQL Job: Log Backup 56:09 SSMS: Create SQL Job: COPY_ONLY Backup 58:54 Backup Cycle Schedule Explained 59:50 Backup Cycle Overlapping Fix 1:04:29 SSMS: Test/Execute SQL Backup Jobs 1:09:09 SQL Job Reports: Verifying Output Files 1:10:17 Backup File and Folder Structure 1:11:27 SSMS: Maintenance Plans 1:19:57 T-SQL: Restore Database - WITH REPLACE 1:22:28 T-SQL: Restore Database - Different Name 1:22:57 T-SQL: Restore Database - Standby / Read-Only 1:23:40 T-SQL: Restore Database - NORECOVERY 1:24:11 SSMS: Restore Database Process 1:29:45 T-SQL: Restore Database WITH RECOVERY 1:30:58 T-SQL: Test Databases for CREATE/INSERT/SELECT 1:31:40 SSMS: Backup and Restore Reports (Events) 1:35:42 T-SQL: Backup and Restore Report 1:36:55 Outro