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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy