Backup and restore your Microsoft SQL Server database

preview_player
Показать описание
If you are someone who works with Microsoft SQL Server a lot, knowing how to backup and restore your SQL Server database is a must required skill. In this tutorial, I will be teaching you two methods (using SQL Server Management Studio and T-SQL script) to backup and restore SQL Server database.

T-SQL scripts used in this video:

Buy Me a Coffee? Your support is much appreciated
Venmo: @Jie-Jenn

More tutorial videos on my website

Check out my gears here on Amazon:
  1. Jie Jenn
  2. backup database for SQL Server
  3. SQL Server database backup
  4. how to backup SQL Server database
  5. how to backup database for SQL Server
Рекомендации по теме
Backup and restore 0:10:54

Backup and restore your Microsoft SQL Server database

Microsoft 365's Latest 0:20:15

Microsoft 365's Latest Update: Backup & Restore Your Data Easily | Peter Rising MVP

How to backup 0:07:57

How to backup and restore your email, contacts, and calendar with Microsoft Outlook

Backup & Restore 0:06:22

Backup & Restore Everything from Old to New PC

How to Back 0:06:41

How to Back Up Your Microsoft 365 Data Using Active Backup for Microsoft 365 | Synology

How to Create 0:06:41

How to Create Full Backup and Restore of Your Windows 11 PC

How Do I 0:07:32

How Do I Restore a Backup to a New PC?

Learn more about 0:02:28

Learn more about Microsoft 365 Backup

How to Set 0:24:42

How to Set up a New Windows 11 Laptop For School - Step by Step

How to Take 0:01:09

How to Take a Backup of your Emails in Outlook? | Microsoft Outlook Tutorial | Microsoft 365

Windows 10 Backup 0:07:23

Windows 10 Backup Free, Fast & Easy with built in Windows 10 Backup

The Best Free 0:13:31

The Best Free Backup for EVERY Operating System

Restore Windows 10 0:03:16

Restore Windows 10 backup to new PC (Easy step by step guide)

How to Explore 0:04:27

How to Explore Files Backed Up Using Windows Backup

How to create 0:03:19

How to create a Microsoft Windows 10 System Image Backup in 9 simple steps plus the restore process.

How to Backup 0:06:26

How to Backup Your Windows 11 to an External Hard Drive #windows11

How to backup 0:06:21

How to backup Outlook EMails and Contacts | 2024 | For Classic Outlook (Not New Outlook)

How to FULL 0:08:54

How to FULL BACKUP Windows 11 OS and Restore Windows 11 Backup (Step by Step) 2024

How to Backup 0:03:49

How to Backup your MS Office 2019/2016 License

Best Backup For 0:29:39

Best Backup For M365: Comparing Microsoft Vs. Third-Party Solutions | Peter Rising MVP

Backup Your Microsoft 0:08:42

Backup Your Microsoft Access Databases - Proper Steps for Backing Up Your ACCDB Database Files

How To Backup 0:03:30

How To Backup And Restore Data Games [Xbox Game Pass PC] Check Desc If Windows App folder Error!!!

SQL Server 2019 0:01:43

SQL Server 2019 | SSMS 2018 | Backup and Restore Databases From One Server To Another server

How to Backup 0:04:19

How to Backup and Restore Windows 10 Files and Folders Via File History Feature Without any Software

Комментарии
Автор

Is there a way to put current date in the backup file name with T-SQL script and run the script with Task Scheduler?

nayzawmoe
Автор

Hi, when dropping database, I always get error like 'Cannot drop database <database name> because it is currently in use. What's the problem?

calvinkoay
Автор

I am not able to get the backup of DB(through T-SQL script), Error -'Statement 'BACKUP DATABASE' is not supported in this version of SQL Server. Can you please mention which version of SSMS are you using? (I am using SSMS 19.0.1) . Also backup and restore option is not there in this version.

bhagyashri