From the course: Microsoft SQL Server 2016 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Basic backups

Basic backups - SQL Server Tutorial

From the course: Microsoft SQL Server 2016 Essential Training

Start my 1-month free trial

Basic backups

“

- [Instructor] Now let's look at the mechanics of creating a backup in SQL Server Management Studio. I'll open up a new query, and I'll type in the key words backup database and then the name of the database I would like to back up. Then I'll say to disk, put an equal sign, and then in single quotes I need to provide the full path and the file name to where I would like to back up. I'm going to go to C:\SQLbackups and that's a folder I just created, and then I'll need to create a file inside of that folder. The default extension for SQL backups is .bak then I'll hit the red exclamation point. Then I get a message at the bottom saying it was successful. The message will list all of the files backed up. Your file list may be a little different from mine depending on how you set up and named your files. We can also do this through the graphical interface. So in Object Explorer I'll open up databases, right click on DemoDBO2, go to Task, and then go to Backup; and that provides an…

Contents