SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Abi Chapagai / Database Mirroring / Latest Posts

RE: Database Mirroring

scottm30 — Thu, 31 Mar 2011 18:36:40 GMT

Nice question, thanks.

RE: Database Mirroring

mohammed moinudheen — Thu, 31 Mar 2011 12:18:36 GMT

Good question. Thank you:-)

RE: Database Mirroring

SQLRNNR — Thu, 31 Mar 2011 09:39:04 GMT

Thanks for the question.

RE: Database Mirroring

SanDroid — Thu, 31 Mar 2011 07:46:47 GMT

Good question. If you know a little bit about the system, catalog, and DMV's on SQL server the answer was easy.Looking at the answers given, I think several people don't know the differance between the Catalog View's and DMV's.The Following are SQL Databases and Files Catalog Views:sys.database_mirroringsys.backup_devicessys.database_filessys.databasessys.database_recovery_statussys.masterfileThere is a full listing of Catalog Views here:[url]http://msdn.microsoft.com/en-us/library/ms174365.aspx[/url]Dynamic Management Views here:[url]http://msdn.microsoft.com/en-us/library/ms188754.aspx[/url]Full listing of system tables by topic is here:[url]http://msdn.microsoft.com/en-us/library/ms179932.aspx[/url]Have fun! :cool:

RE: Database Mirroring

tejaswini.patil — Thu, 31 Mar 2011 05:01:08 GMT

Thanks for the question. It was a learning for me. :-)

RE: Database Mirroring

Gobikannan — Thu, 31 Mar 2011 01:19:36 GMT

Good question with clear history...

RE: Database Mirroring

UMG Developer — Thu, 31 Mar 2011 00:00:49 GMT

Thanks for the question, it is always good to research and learn something new!

RE: Database Mirroring

Koen Verbeeck — Wed, 30 Mar 2011 23:41:13 GMT

Nice question, thanks.

RE: Database Mirroring

bitbucket-25253 — Wed, 30 Mar 2011 20:58:34 GMT

A very good, clear, concise question. Found out I knew something.

Database Mirroring

Abi Chapagai — Wed, 30 Mar 2011 20:57:06 GMT

Comments posted to this topic are about the item [B]Database Mirroring[/B]