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 |
|