filmov
tv
SQL Server DBA Interview Questions - 01

Показать описание
What purpose does the Model Database Serve?
The model database is used as the template for all databases created on an instance of SQL Server.
Because tempdb is created every time SQL Server is started, the model database must always exist on a SQL Server system.
The entire contents of the model database, including database options, are copied to the new database.
The model database is used as the template for all databases created on an instance of SQL Server.
Because tempdb is created every time SQL Server is started, the model database must always exist on a SQL Server system.
The entire contents of the model database, including database options, are copied to the new database.