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 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. You do not have to restore these databases, if you just want to restore a user database. For more information on Microsoft SQL Server `model, `msdb and `distribution database, please visit http://www.microsoft.

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. You do not have to restore these databases, if you just want to restore a user database. For more information on Microsoft SQL Server `model, `msdb and `distribution database, please visit http://www.microsoft.com/sql/.