Database Properties (General Page)
Applies to: SQL Server Azure SQL Managed Instance
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 configured for the database.
Collation Name
Displays the collation used for the database. The collation can be changed on the Options page.
See Also
ALTER DATABASE (Transact-SQL)
ALTER DATABASE (Azure SQL Database)
sys.databases (Transact-SQL)
DATABASEPROPERTYEX (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for