From the course: SQL Server 2014 Essential Training

Unlock the full course today

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

Basic backups

Basic backups - SQL Server Tutorial

From the course: SQL Server 2014 Essential Training

Start my 1-month free trial

Basic backups

“

- Now I'd like to demonstrate backing up a database in SQL Server 2014. I've selected the AdventureWorks2014 database. I'm gonna right click on it, and in the menu that pops up, I'll select Task, and off the Task menu, we have the option to Back Up. This will open up a dialogue, where I can set the different options about the backup. First option its asking me which Database I would like to back up, and it has a drop down with a list of all of them. AdventureWorks2014 is the one that I want. Its asking me to do a Full or a Differential. I'd like to do a full. And I can either back up to Disk, or a URL. And for this example, I'd like to back up to Disk. It has a file already selected, but that's not the one I want to use, so I'll remove that, and I'll hit Add to add a new one. It is suggesting a destination for me. Its the default destination that we chose when we set up this SQL Server instance. And that is in fact a good place to put the back up. So I'll just need to select a file…

Contents