Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

When should I restore the model, msdb and distribution databases?

April 26, 2017databases distribution model restore

0

Posted

When should I restore the model, msdb and distribution databases?

2 Answers

0

Posted

You should restore the ‘model’ database, if you have changed the database template of your MS SQL Server. You need to restore the ‘msdb’ database, if you have changed the scheduling information or you want to restore the backup and restore history of your databases. If you are running the replication components of MS SQL Server, then restore your ‘distribution’ database.

0

Posted

Restore the model database if you have changed the database template of your MS SQL Server. Restore the msdb database if you have changed the scheduling information or want to restore the backup and restore history of your databases. If you are running the replication components of MS SQL Server, then restore your distribution database. You need not restore these databases if you just want to restore a user database. For more information on Microsoft SQL Server model, msdb and distribution database, click http://www.microsoft.com/sql/.