From the course: Database Foundations: Administration
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Create a full SQL Server backup
From the course: Database Foundations: Administration
Create a full SQL Server backup
- [Instructor] Microsoft's SQL server takes a slightly different approach to making database backups and restoring them. Unlike PostgreSQL, which relies on external command line tools, SQL server uses SQL commands that you can execute right inside of the RDBMS, just like any other query that you might want to run. However, the main concepts are exactly the same. The backup procedure makes a copy of all of the object structures and data that are currently stored and packages it into a single file that can be archived. Everything that the RDBMS needs to restore the database to its current state is contained in the backup file. This allows you to move it to a protected offsite location for safekeeping, and use it to recover from, should you ever need it. Let's take a look at this process here in Azure Data Studio. First, I'm going to right-click on the two trees database that's in the SQL server instance and choose Manage.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.