1433 - MSSQL - Microsoft SQL Server

Microsoft SQL Server is a database management system developed by mIcrosoft. As a database server, it stores and is capabable of retrieving data as requested by software applications.

Default MS-SQL System Tables

  • master Database: this database captures all system-level details for a SQL server instance

  • msdb Database: SQL Server Agent utilitzes this database to manage scheduling for alerts and jobs

  • model Database: Acts as a blueprint for every new database on the SQL Server instance, where any alterations like size, collation, recovery model, and more are mirrored in newly created databases.

  • Resource Database: a read-only database that houses system objects that come with SQL server.

  • tempdb Database: Serves as a temporary storage area for transient objects or intermediate result sets.

Last updated