PrepAway - Latest Free Exam Questions & Answers

Tag: sql server alerts

What should you do to define the alerts for the databases in this scenario?

You are the database administrator for your company. You maintain a database named Sql_ny on a SQL Server2008 instance named Sql1.
This server is located at the head office in New York. You have created 30 differentalerts on this database server.
Your company has recently opened two new branch offices in London and Paris.
The databases, named Sql_lon and Sql_par, in the London and Paris branch offices reside on SQL Server 2008 instances named Sql2 and Sql3, respectively.
The data in these databases is similar to the data stored in the Sql_ny database.
You are now required to define alerts on the Sql_lon and Sql_par databases and on the Sql_ny database.
What should you do to define the alerts for the databases in this scenario?