![]() ![]() The msdb database is used mainly by the SQL Server Agent, and also by other features like SQL Server Management Studio, Service Broker, and Database Mail. Therefore, the model database must always exist on the SQL Server. The tempdb is created from the model database each time SQL Server starts. If you modify the model database, all the changes made in the model database will be reflected on all the databases created using it. The model database information including tables, stored procedures, etc, that are created on it will be copied when a new database is created using the model database template. The model database is used as a template for other databases created in SQL Server, especially when creating user-defined databases. Rebuilding the master database rebuilds all of the system databases. You need to either rebuild the Master Database or recover from backup. Therefore, it is always recommended to maintain a current backup of the master database. If the master database becomes unusable or corrupted, you need to bring the database back to its usable state as SQL Server cannot start if the master database is unavailable.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |