March 30, 2011 at 8:57 pm
Comments posted to this topic are about the item Database Mirroring
March 30, 2011 at 8:58 pm
March 30, 2011 at 11:41 pm
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 31, 2011 at 12:00 am
Thanks for the question, it is always good to research and learn something new!
March 31, 2011 at 1:19 am
Good question with clear history...
-----------------
Gobikannan
March 31, 2011 at 5:01 am
Thanks for the question. It was a learning for me. 🙂
March 31, 2011 at 7:46 am
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_mirroring
sys.backup_devices
sys.database_files
sys.databases
sys.database_recovery_status
sys.masterfile
There is a full listing of Catalog Views here:
http://msdn.microsoft.com/en-us/library/ms174365.aspx
Dynamic Management Views here:
http://msdn.microsoft.com/en-us/library/ms188754.aspx
Full listing of system tables by topic is here:
http://msdn.microsoft.com/en-us/library/ms179932.aspx
Have fun! 😎
March 31, 2011 at 9:39 am
Thanks for the question.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 31, 2011 at 12:18 pm
Good question. Thank you:-)
M&M
March 31, 2011 at 6:36 pm
Nice question, thanks.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply