From the course: SQL Server 2022 Administration

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Create and verify backups

Create and verify backups - SQL Server Tutorial

From the course: SQL Server 2022 Administration

Start my 1-month free trial Buy for my team

Create and verify backups

“

So in this lesson, we're actually going to go ahead and create some backups of our various SQL Server databases. Now, as with everything in SQL Server, I can do this via the GUI or I can do this via Transact-SQL scripts. I could even use external like SQL command line stuff in order to do it. We're going to focus on the GUI and the scripts and I will encourage you as you start learning backups and as you start creating them, the GUI is great if you have to do a quick one-off backup, but get used to how the scripts look and how to work with backup scripts because eventually you're going to want to automate your backups. And the best way to do that is to script out the way you want and then you can create jobs and you can do all this other stuff. Now you can use the GUI to help, but being familiar with the scripts is going to help you in the long run. Okay. With that, we'll dive right in and we'll do some backups here. So the WideWorldImporter's database. And I'll start by showing you…

Contents