SQL Server system databases


show more SQL Server system databases provides you with in-depth training on Business. Taught by Simon Allardice as part of the SQL Server 2008 Essential Training show less
please wait ...

SQL Server system databases

Now although when you install SQL Server, you don't get any of the sample databases like AdventureWorks, what you will see, if you're looking through SQL Server Management Studio, is you will see at least four system databases. Four is pretty typical for a right- out-of-the-box standard installation. You have got master, model, msdb, and tempdb and I'm often ask how important are these and are you supposed to do anything with them, are you supposed to change them? Well in this particular course, we're unlikely to touch any of them at all.

You are just going to leave them alone but to give you the quick runthrough of what they mean, yes, they are important, they are vital. The master database, which even sounds important straight off the bat, is the one database that says what exists in this instance of SQL Server. If the master database wasn't available, the instance doesn't even start. It won't run. This says what else is available. The model database can be cha...

SQL Server system databases
Video duration: 2m 22s 6h 54m Beginner

Viewers:

SQL Server system databases provides you with in-depth training on Business. Taught by Simon Allardice as part of the SQL Server 2008 Essential Training

Subjects:
Business Developer IT
Software:
SQL Server
Author:
please wait ...