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

1. Last Database Backup
   
2. Last Database Log Backup 
    
3. Database Name 
    
4. State of the Database Status 
    
5. Database Owner 
    
6. Date Database Was Created 
    
7. Size of the Database 
    
8. Space Available 
    
9. Number of Users Currently Connected to the Database 
    
10. 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

Comments On: Handling Database Properties for the SQL Server 2005 Database Engine

>>> Be the FIRST to comment on this article!