Join Ron Davis for an in-depth discussion in this video Managing the system databases, part of Installing and Administering Microsoft SQL Server 2014.
- View Offline
- Exercise Files
- System Databases, there's six of them:…master, resource, model,…MSDB, distribution, and tempDB.…The master, so called, because it stores…information about the entire server.…So your logons are stored there, the way you…configured the server is stored there, et cetera,…information that applies to the entire server.…Now this should come as no surprise.…If SQL can't find the master, if the master's corrupt…or something like that, it won't start and if you actually…ever do a search Corrupt Master in SQL,…you'll come back with a number of different links.…
The resource database, that contains…the system objects and the system views.…You'll never see it in SQL Server Management Studio.…There's a good reason you can't see it.…We don't want you to fool with it.…So you won't see it, you know it's there, let it alone.…Model, now the model, so called, because when you…create a user database, the model is the template…that is used to output the user database.…
So what's that mean?…The initial settings of the model will translate…
- Planning SQL Server installation
- Installing SQL Server 2014
- Using the tools: SQL Server Management Studio, PowerShell, and more
- Managing the databases
- Automating maintenance
- Performing backups and recovery
- Importing and exporting data
- Indexing databases
- Monitoring activity, performance, and events
- Implementing security
Skill Level Intermediate
Relational Database Fundamentalswith Adam Wilbert2h 40m Beginner
SQL Server 2014 Essential Trainingwith Martin Guidry3h 51m Intermediate
1. Installing SQL Server 2014
2. Learning the SQL Server Tools
Using the sqlcmd utility7m 58s
3. Understanding Data Storage
4. Automating Maintenance of SQL Server
5. Implementing a Backup Plan
6. Importing and Exporting Data
Working with the bcp utility8m 12s
7. Indexing the Databases
8. Monitoring SQL Server
9. Understanding SQL Server Security
Next steps2m 27s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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.