From the course: Microsoft SQL Server 2016 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 restore

Basic restore - SQL Server Tutorial

From the course: Microsoft SQL Server 2016 Essential Training

Start my 1-month free trial

Basic restore

“

- Now we'll look at restoring a database and the commands to do this are very similar to the commands to backup a database, so I've left the command on the screen, this is the command I had used to backup the database. To do the restore I would just change the word backup to restore. Instead of going to a disc we're going from the disc. Because this database is online right now I'll need to specify that I want to overwrite the existing database, so I'll have to specify with replace, and that will replace the database that is currently online. So hit execute and it takes a little bit longer than the backup did but eventually we get a message saying restore database successful, and we see all of the different files that were restored. Through the graphical interface I'll right click on demo DB02, go to task, go to restore, and I'll go to database. In this interface we have the option to either restore from a database or restore from a device, and a file is a type of device in this…

Contents