Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - System Databases Used by SQL Servers

By: FYIcenter.com

(Continued from previous topic...)

What are system databases?

System databases are created by the SQL Server itself during the installation process. System databases are used by the SQL server to help manage other user databases and client execution sessions. SQL Server 2005 Express Edition uses 4 system databases:

  • master - The brain of a SQL server - Stores server configuration, runtime information, and database metadata.
  • model - An empty database model - Used to clone new databases.
  • msdb - The background job scheduler - Used for background jobs and related tasks.
  • tempdb - The temporary database - Used by the server as a scratch pad.

  1. What is a database?
  2. What is the simplest way to create a new database?
  3. How to set the current database?
  4. How to delete a database?
  5. Why I am getting this error when dropping a database?
  6. How to get a list all databases on the SQL server?
  7. Where is my database stored on the hard disk?
  8. How to create database with physical files specified?
  9. How to rename databases?
  10. Why I am getting this error when renaming a database?
  11. What are database states?
  12. How to set a database state to OFFLINE?
  13. How to move database physical files?
  14. How to set database to be READ_ONLY?
  15. How to set database to be SINGLE_USER?
  16. What are system databases?

Related Articles:


Other Tutorials/FAQs:


Related Resources:


Selected Jobs: