Join Adam Wilbert for an in-depth discussion in this video Using SSMS to restore a database, part of Database Foundations: Core Concepts.
- So right now, this instance of SQL Server…only has the system databases.…We don't have any user databases created.…Let's go ahead and add one from our exercise files.…I'm going to collapse this back down…to clean up my screen a little bit…and then we'll right click on Databases…and we'll choose Restore Database.…This will allow us to restore a database…from a backup file.…On the Restore Databases stream,…if we've previously established some backups…within this instance of SQL Server,…we would find them on this drop down list here…but I don't have any at the moment.…Instead what I need to do is change the Source to Device.…
That'll allow me to choose a backup file…that's on my current hard drive.…On the far right, I'll press this button here…with the ellipses or the three dots to choose the file…and that'll pull up a window…that says Select Backup Devices.…We can either choose to pull a backup…from a File or a URL.…I'm going to leave it on file.…And we'll press add to find the backup file.…Now, that's going to open up this window here…
Author
Adam Wilbert
Released
8/13/2015Note: This course will also prepare certification candidates for the Microsoft Technology Associate Exam 98-364, Database Administration Fundamentals.
- Understanding flat file, hierarchical, and relational databases
- Installing SQL Server 2014 Express
- Creating your first database and tables
- Creating and editing database objects
- Writing commands in DML
- Selecting and inserting data
- Updating and deleting data
- Establishing relationships and file naming conventions
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome1m 16s
-
-
1. Understanding Data Storage Models
-
What are databases?3m 16s
-
Calculating values1m 40s
-
-
2. Building Your Server
-
Introducing views5m 23s
-
3. Understanding Data Definition Language (DDL)
-
Removing objects with DROP1m 41s
-
4. Understanding Data Manipulation Language (DML)
-
Writing commands in DML1m 21s
-
Selecting data from a table4m 30s
-
Updating data3m 50s
-
Merging data tables5m 27s
-
Solution: Using DML4m 37s
-
-
5. Understanding Relational Database Concepts
-
Establishing relationships2m 58s
-
Exploring data constraints3m 23s
-
Adding indexes to tables1m 44s
-
Following naming conventions1m 32s
-
-
Conclusion
-
Next steps54s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Using SSMS to restore a database