SQL Server 2016 Part 3 - System Databases, Backing Up and Restoring

By Andrew Gould

[arvindhmani]

"Not the most exciting video in the world" but comprehensive and well explained. Thank you!!

[adocsgo]

2:15 Master Database Section
3:38 Backing up Master DataBase
5:40 Start of Lesson : Trying to restore Master Database
6:45 Error if trying to restore when not in Single User Mode
7:20 Using SQL Server Configuration Manager
7:55 Modifying how the SQL engine works
8:02 Starting SQL Server in Single-User Mode
9:45 Querying Server in Single-User Mode
10:23 Setting the query to SQLCMD Mode
11:05 Writing the Restore Database Command
13:00 Executing the Restore Database Command
14:50 Repairing an SQL Server Installation
16:30 The Model Database and Creating Objects (Template for any new Database)
17:25 New Table Desigining
18:05 Refresh Tut
18:15 Changing Properties of the Model Database
18:35 Options Portion of Properties for Model Database
19:30 New Databases Inherit from Model Database
20:37 Breaking up and Restoring the Model Database
21:28 The MSDB Database (keeps track of automated ...)
22:33 Viewing Backup Logs (dbo.backupset)
23:40 Backing up the MSDB Database
24:30 The Tempdb Database and Creating Objects (temporary objects - delete when service restarts)
26:45 Tempdb inherits from the Model Database
28:16 Why you can't backup the Tempdb
28:45 Recap and What's Next

[markmilingo]

WiseOwl should be called super WiseOwl, great tutorials. I'm learning SQL and this stuff is concise. Thanks

[robbiedarza]

Many thanks for your videos, Im starting a database module in uni in a couple of weeks and already, even though im only on part 3, I feel really much better having a headstart. Really clear easy to follow steps with everything explained perfectly, will definitely be recommending this as a must watch for my classmates. Thanks, again.

Robbie.

[evaism]

Watching this at 11:30 PM, still fun!

[androidgaming]

These videos are really helpful and your voice is also good .

[bencole]

Very concise as always, thank you Andrew.

[hthclash]

Rip headphones users, I hope in next videos going to be fine. Thanks for the video anyway.

[samg]

I've really been enjoying some of your videos....I noticed in a few of your videos you mention that you're just introducing the features and not looking to cover the tasks expected of a DBA... I'm wondering if you have a line of videos that will lead one  down the "DBA path" (using SQL).. I'd be interested in the course list you'd recommend.  I'm really enjoying the way you cover the material in your vids.  thanks.

[TheMorganNSK]

HINT: 9:50 You should make sure first that the SQL Server Agent Service is stopped (just like made in this video).
Otherwise, the SQL Server Agent service uses the connection, thereby blocking it.

[caribeiro]

As always, excellent video...
I would love to make a sugestion for a future series of videos, i would love to see how to work with excel and SQL databases... that is, i would like to have my Database/Tables in SQL and manipulate them with Excel, i would like to take of my data from Excel and store it in SQL since if i'm dealing with udge data in Excel my Excel book turns to slow....
Thanks..

[iistrideii]

When I right click Task, I don't have a backup option for my master folder. @3:48.
Did I do something wrong?

[maximebarsamian]

hello, thx for this videos. It's perfect for beginners. Unfortunately, my sql server is slow. For example when i want to see properties after right click on a table..It's very slow...I don't understand...do you know why ?

[pianoLee-sxdx]

Another interesting tutorial but is it case sensitive when we type the query commands?

[allmazd]

Isn't it easier to go to single user mode by a t-sql command inside sql manager rather than doing all these voodoo things you described?

[everythinisfine]

Can I choose the Master database as a Partial database?

[paulmakauskas]

Hello, I followed every single step and attempt to put in a new query in order to restore the database in my SQL Server, the follwoing error message pops up: LOGIN FAILED... SERVER IS IN SINGLE USER MODE, ONLY ONE ADMINISTRATOR CAN CONNECT AT THIS TIME. Could you please advise what I'm doing wrong? Thanks.

[zakariabelagoune]

i need to backup database using bacula .... do you have anny idea

[bashersarkar]

How can i add "AdventureWorksDW2016.bak" this file in my SQL Server 2012?