Multiple choice technology databases

This database will be flushed when SQL Server restarts

  1. model

  2. msdb

  3. tempdb

  4. MSSQLSystemResource
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

tempdb is a system database in SQL Server that is recreated every time the SQL Server service restarts. It stores temporary objects and is always empty when SQL Server starts. The master database contains system metadata, msdb stores SQL Agent jobs and other service information, and MSSQLSystemResource is a read-only database containing system object definitions - none of these are flushed on restart.

Keep practicing — related questions