SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Language Reference

Transact-SQL Reference

System Views (Transact-SQL)

Catalog Views (Transact-SQL)

Databases and Files Catalog Views (Transact-SQL)

sys.backup_devices (Transact-SQL)

sys.databases (Transact-SQL)

sys.database_files (Transact-SQL)

sys.database_mirroring (Transact-SQL)

sys.database_recovery_status (Transact-SQL)

sys.master_files (Transact-SQL)

Minimize

0 out of 2 rated this helpful - Rate this topic

Databases and Files Catalog Views (Transact-SQL)

SQL Server 2005

This section contains the following catalog views.

sys.backup_devices	sys.database_files
sys.databases	sys.database_mirroring
sys.database_recovery_status	sys.master_files

Reference

Catalog Views (Transact-SQL)
System Views (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.