Home » Microsoft » 70-765 » Does the solution meet the goal?
You plan to migrate a Microsoft SQL server instance between physical servers.
You must migrate the metadata associated with the database instance.
You need to ensure that the new instance retains the existing jobs and alerts.
Solutions: You restore the service master key.
Does the solution meet the goal?
A. Yes
B. No
Correct Answer: B
Explanation/Reference:
Explanation:
The Service Master Key is the root of the SQL Server encryption hierarchy. It does not handle alerts and jobs.
The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as SQL Server Management Studio, Service Broker and Database Mail.
References: https://docs.microsoft.com/en-us/sql/relational-databases/databases/msdb-database?view=sql-server-2017