• 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! 😎