# [Overview](databases.md)  
# [System Databases](system-databases.md)  
## [master Database](master-database.md)  
## [model Database](model-database.md)  
## [msdb Database](msdb-database.md)  
## [Resource Database](resource-database.md)  
## [tempdb Database](tempdb-database.md)  
## [Rebuild System Databases](rebuild-system-databases.md)  
# [Contained Databases](contained-databases.md)  
## [Modified Features (Contained Database)](modified-features-contained-database.md)  
## [Contained Database Collations](contained-database-collations.md)  
## [Security Best Practices with Contained Databases](security-best-practices-with-contained-databases.md)  
## [Migrate to a Partially Contained Database](migrate-to-a-partially-contained-database.md)  
# [SQL Server Data Files in Microsoft Azure](sql-server-data-files-in-microsoft-azure.md)  
# [Database Files and Filegroups](database-files-and-filegroups.md)  
# [Database States](database-states.md)  
# [File States](file-states.md)  
# [Database Identifiers](database-identifiers.md)  
# [Estimate the Size of a Database](estimate-the-size-of-a-database.md)  
## [Estimate the Size of a Table](estimate-the-size-of-a-table.md)  
## [Estimate the Size of a Clustered Index](estimate-the-size-of-a-clustered-index.md)  
## [Estimate the Size of a Nonclustered Index](estimate-the-size-of-a-nonclustered-index.md)  
## [Estimate the Size of a Heap](estimate-the-size-of-a-heap.md)  
# [Copy Databases to Other Servers](copy-databases-to-other-servers.md)  
## [Use the Copy Database Wizard](use-the-copy-database-wizard.md)  
## [Copy Databases with Backup and Restore](copy-databases-with-backup-and-restore.md)  
## [Publish a Database (SQL Server Management Studio)](publish-a-database-sql-server-management-studio.md)  
## [Deploy a SQL Server Database to a Microsoft Azure Virtual Machine](deploy-a-sql-server-database-to-a-microsoft-azure-virtual-machine.md)  
# [Database Detach and Attach](database-detach-and-attach-sql-server.md)  
## [Move a Database Using Detach and Attach (Transact-SQL)](move-a-database-using-detach-and-attach-transact-sql.md)  
## [Upgrade a Database Using Detach and Attach (Transact-SQL)](upgrade-a-database-using-detach-and-attach-transact-sql.md)  
## [Detach a Database](detach-a-database.md)  
## [Attach a Database](attach-a-database.md)  
# [Add Data or Log Files to a Database](add-data-or-log-files-to-a-database.md)  
# [Change the Configuration Settings for a Database](change-the-configuration-settings-for-a-database.md)  
# [Create a Database](create-a-database.md)  
# [Delete a Database](delete-a-database.md)  
# [Delete Data or Log Files from a Database](delete-data-or-log-files-from-a-database.md)  
# [Display Data and Log Space Information for a Database](display-data-and-log-space-information-for-a-database.md)  
# [Increase the Size of a Database](increase-the-size-of-a-database.md)  
# [Manage Metadata When Making a Database Available on Another Server Instance](manage-metadata-when-making-a-database-available-on-another-server.md)  
# [Move Database Files](move-database-files.md)  
## [Move User Databases](move-user-databases.md)  
## [Move System Databases](move-system-databases.md)  
# [Rename a Database](rename-a-database.md)  
# [Set a Database to Single-user Mode](set-a-database-to-single-user-mode.md)  
# [Shrink a Database](shrink-a-database.md)  
# [Shrink a File](shrink-a-file.md)  
# [View or Change the Properties of a Database](view-or-change-the-properties-of-a-database.md)  
## [Value for Extended Property Dialog Box](value-for-extended-property-dialog-box.md)  
## [Database Object (Extended Properties Page)](database-object-extended-properties-page.md)  
## [Database Properties (General Page)](database-properties-general-page.md)  
## [Database Properties (Files Page)](database-properties-files-page.md)  
## [Database Properties (Filegroups Page)](database-properties-filegroups-page.md)  
## [Database Properties (Options Page)](database-properties-options-page.md)  
## [Database Properties (ChangeTracking Page)](database-properties-changetracking-page.md)  
## [Database Properties (Transaction Log Shipping Page)](database-properties-transaction-log-shipping-page.md)  
### [Log Shipping Transaction Log Backup Settings](log-shipping-transaction-log-backup-settings.md)  
### [Secondary Database Settings](secondary-database-settings.md)  
### [Log Shipping Monitor Settings](log-shipping-monitor-settings.md)  
## [Database Properties (Mirroring Page)](database-properties-mirroring-page.md)  
## [Database Properties (Query Store Page)](database-properties-query-store-page.md)  
# [View a List of Databases on an Instance of SQL Server](view-a-list-of-databases-on-an-instance-of-sql-server.md)  
# [View or Change the Compatibility Level of a Database](view-or-change-the-compatibility-level-of-a-database.md)  
# [Create a User-Defined Data Type Alias](create-a-user-defined-data-type-alias.md)  
# [Database Snapshots](database-snapshots-sql-server.md)  
## [View the Size of the Sparse File of a Database Snapshot (Transact-SQL)](view-the-size-of-the-sparse-file-of-a-database-snapshot-transact-sql.md)  
## [Create a Database Snapshot (Transact-SQL)](create-a-database-snapshot-transact-sql.md)  
## [View a Database Snapshot (SQL Server)](view-a-database-snapshot-sql-server.md)  
## [Revert a Database to a Database Snapshot](revert-a-database-to-a-database-snapshot.md)  
## [Drop a Database Snapshot (Transact-SQL)](drop-a-database-snapshot-transact-sql.md)  
# [Database Instant File Initialization](database-instant-file-initialization.md)