From the course: Database Foundations: Administration

Unlock the full course today

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

Restore a SQL Server database

Restore a SQL Server database

From the course: Database Foundations: Administration

Start my 1-month free trial

Restore a SQL Server database

“

- Restoring a database on SQL server requires a similar procedure as making the initial backup. You use an SQL command to read the backup file and recreate the database. One of the major differences between SQL server and PostgreSQL in this area is that PostgreSQL needs an empty database to restore into whereas SQL server creates the database as part of the restoration process. Now, instead of creating yet another Docker container, I'm just going to demonstrate with the SQL server instance that we already have. In the previous movie, I created a backup for the Two Trees database. Let's delete it from the server and then restore it from the backup. Now, I wouldn't say that deleting a mission critical database is a common operation but let's suppose that we have a disgruntled employee on our hands and they decided to wreck havoc on the company, they right click on the server and choose new query, then they issue the…

Contents