YOU’VE JUST UPGRADED TO SQL SERVER 2008 FROM SQL SERVER 2000, AND...

13. You’ve just upgraded to SQL Server 2008 from SQL Server 2000, and you’ve

dropped SQLMail in favor of Database Mail. The IT manager wants to know

if Database Mail has redundancy if a mail server goes down. How would

you reply?

A. Yes, you can configure multiple SMTP servers in a Database Mail Profile.

B. Yes, you can configure SQLMail as a backup.

C. No, you would have to reconfigure it to use a different mail server.

D. Yes, Database Mail is supported on a failover cluster.

Correct Answer & Explanation: A. If the first SMTP server isn’t contactable,

Database Mail will try the next configured server.

Incorrect Answers & Explanations: B, C, D. Answer B is incorrect because

SQLMail and Database Mail don’t work together. Answer C is incorrect

because you can specify multiple SMTP servers. Answer D is incorrect

because the question refers to a mail server going down, not Database Mail

going down.