nick.welham (2/3/2011)
Two questions, if someone could help me please!1. Does the Master DB contain the server Master encryption key data or should I add this separately?
2. I know the Master db contains the code for the scheduled agents, but if I follow the rebuild sequence outlined will they appear in the SQL Server Agent Jobs automatically, or do I need to dig the code out for each step and recreate it?
Thank you!
Welham,
Encryption key data should always be backed up on their own regardless of where it lives.
Also the jobs are contained in the MSDB database.
Rudy