From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Perform a database restore using database tools

Perform a database restore using database tools

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Perform a database restore using database tools

“

- Welcome back, this is lesson 14.3. Perform a database restore by using database tools. Okay, let's walk through how to perform a database restore using the built-in database tools. And again, by database tools, we're referring to SQL Server Management Studio here. So in SQL Server Management Studio, right click on the database's node and select Restore Database. If you want to restore over an existing database, you can right click on the specific database, select Tasks, and then select Restore, and then select Database. But regardless, you'll get a Restore Wizard. On the general page, the first step is to select the source. You have two options. Database and this selects the database tree store from the dropdown list. The list contains only databases that have been backed up according to the MSDB backup history. For device, you want to select this option if you want to restore from a file such as a .BAK or a device such as a tape or even a URL. If you select device, you then need to…

Contents