Handling Database Properties for the SQL Server 2005 Database Engine
(Page 1 of 4 )
In this fourth part of a six-part series on administering SQL Server 2005 database engine, you will learn how to manage the database properties general page, and more. This article is excerpted from chapter one of the book
SQL Server 2005 Management and Administration, written by Chris Amaris, Alec Minty and Ross Mistry (Sam Publishing, 2008; ISBN: 0672329565).
Administering the Database Properties General Page
General, the first page in the Database Properties dialog box, displays information exclusive to backups, database settings, and collation settings. Specific information displayed includes
- Last Database Backup
- Last Database Log Backup
- Database Name
- State of the Database Status
- Database Owner
- Date Database Was Created
- Size of the Database
- Space Available
- Number of Users Currently Connected to the Database
- Collation Settings
You should use this page for obtaining factual information about a database, as displayed in Figure 1.11.

Figure 1.11. Viewing the General page in the Database Properties dialog box.
Next: Administering the Database Properties Files Page >>
More Database Articles
More By Sams Publishing