Meta Data Services uses msdb as the default repository database. If msdb is not restored, and is not accessible, SQL Server Agent cannot access or initiate any previously scheduled tasks. This results in a loss of all scheduling information, as well as the backup and restore history. If msdb contains scheduling or other data used by the system, it is necessary to restore msdb from a backup when you rebuild master because the utility deletes and re-creates msdb. Restore of backups of these databases made on SQL Server version 7.0 or earlier is not supported.
The model and msdb databases can only be restored from backups created on a Microsoft® SQL Server™ 2000 server. In this case, it is necessary to restore model from a backup when you rebuild master because the Rebuild Master utility deletes and re-creates model.
0 kommentar(er)
