edwina derrick (12/2/2010)
I want to take a backup of msdb on server A and restore it to server B. Has anyone done this in SQL Server 2008
You can simply restore msdb from a backup that you have made as long as no
one is using it. That really means to just stop the SQL Server Agent
process and restore the database and then start the Agent back up.
edwina derrick (12/2/2010)
does it require an update to msdb tables for the server name like SQL Server 2005?
NO.This will be automatically handled by sql server.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)