:::: MENU ::::

Posts Categorized / Mirroring

  • Nov 12 / 2008
  • 0
dbDigger, Mirroring, Monitoring and Analysis, System Stored Procedures

Monitor DB mirroring session in SQL Server 2008

Question: In SQL Server 2008, if you want to use a stored procedure to monitor the status of your database mirroring session, which one would you use?

Answer: sp_dbmmonitorresults

Explanation: The sp_dbmmonitorresults procedure will return the current status of your database that is being mirrored.

Ref: sp_dbmmonitorresults

Note: The Question is taken from SQLServercentral.com.

Consult us to explore the Databases. Contact us