Database Properties Page (General)

Use this page to view or modify properties for the selected database.

Options

  • Last Database Backup
    Displays the date that the database was last backed up.
  • Last Database Log Backup
    Displays the date that the database transaction log was last backed up.
  • Name
    Displays the name of the database.
  • Status
    Displays the database state. For more information, see Database States.
  • Owner
    Displays the name of the database owner. The owner can be changed on the Files page.
  • Date Created
    Displays the date and time that the database was created.
  • Size
    Displays the size of the database in megabytes.
  • Space Available
    Displays the amount of available space in the database in megabytes.
  • Number of Users
    Displays the number of users connected to the database.
  • Collation Name
    Displays the collation used for the database. The collation can be changed on the Options page.

See Also

Other Resources

ALTER DATABASE (Transact-SQL)
Modifying a Database
sys.databases (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

14 April 2006

New content:
  • Added the Status section.
Changed content:
  • Updated the Collation Name paragraph.