From the course: SQL Server 2008 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

SQL Server system databases

SQL Server system databases - SQL Server Tutorial

From the course: SQL Server 2008 Essential Training

Start my 1-month free trial

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 changed but you're…

Contents