More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
What do you need to do now to ensure you can recover the routes in the event of a disaster?
You have setup forwarding for your SQL Server 2005 Service Broker queues to another server. You edit a route to move a queue to a new server. What do you need to do now to ensure you can recover the routes in the event of a disaster?
Answer
Back up the msdb database.
Explanation
The routes for forwarding are stored in msdb.sys.routes. If you back up the msdb database, the routes will be captured.
(Continued on next question...)
