The tempdb Database
In some ways, your tempdb database is just like any other database, but it has some unique behaviors. They are not all relevant to the topic of this chapter, so I will provide some references to other chapters where you can find additional information.
As mentioned earlier, the biggest difference between tempdb and all the other databases in your SQL Server instance is that tempdb is re-created–not recovered–every time SQL Server is restarted. You can think of tempdb as a workspace for temporary user objects and internal objects explicitly created by SQL Server itself.
Every time tempdb is re-created, it inherits most database options from the model database. However, the recovery mode is not copied because tempdb always uses ...
Get Inside Microsoft® SQL Server™ 2005, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
