10.2 Properties of the database

10.2 Properties of Database objects

10.2.1 viewing the properties of a database

You can display the database properties form by selecting Properties from the right-click menu.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6C/22/wKiom1VAiC2AfC4AAAI3ZK2Nxz8120.jpg "title=" property. png "alt=" Wkiom1vaic2afc4aaai3zk2nxz8120.jpg "/>

10.2.2 Database Properties-"General"

Use the General tab to view the basic information for the selected database.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6C/1E/wKioL1VAiajTYhPmAAJ45mhobfo652.jpg "style=" float: none; "title=" 1 general. png "alt=" wkiol1vaiajtyhpmaaj45mhobfo652.jpg "/>

10.2.3 Database Properties-"Files" and "filegroups"

The Filegroups and Files tabs show the filegroup configuration and database files for the selected database.
You can assign data files to multiple drives or multiple folders by using a combination of filegroups and files. SQL Server creates a PRIMARY filegroup by default when the database is created, and includes a data file in the filegroup. Filegroup configuration does not apply to log files.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6C/22/wKiom1VAiEHjZyUbAAJKFwDpFsM057.jpg "style=" float: none; "title=" 2 file. png "alt=" wkiom1vaiehjzyubaajkfwdpfsm057.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6C/1E/wKioL1VAianCRG4uAAI-iM7HAdA377.jpg "style=" float: none; "title=" 3 filegroup. png "alt=" wkiol1vaiancrg4uaai-im7hada377.jpg "/>

10.2.4 Database Properties-"Options"

You can view or modify options for the selected database in the Options tab.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6C/22/wKiom1VAiELSg3meAAMpjjLRA3o823.jpg "style=" float: none; "title=" 04 option. PNG "alt=" wkiom1vaielsg3meaampjjlra3o823.jpg "/>

10.2.5 Database Properties-"Change Tracking"

Use this tab to view or modify change tracking settings for the selected database.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6C/1E/wKioL1VAiaqRgQ0-AAHJFCSMYN4974.jpg "style=" float: none; "Title=" 05 change tracking. png "alt=" wkiol1vaiaqrgq0-aahjfcsmyn4974.jpg "/>

10.2.6 Database Properties-"Permissions"

Use the Permissions tab to view or set permissions for securable objects.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6C/22/wKiom1VAiEPCiONqAAIFbu8Sy0U513.jpg "style=" float: none; "title=" 06 permissions. png "alt=" wkiom1vaiepcionqaaifbu8sy0u513.jpg "/>

10.2.7 Database Properties-"Extended Properties"

Using the Extended Properties tab, you can add custom properties to database objects.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6C/1E/wKioL1VAiavRrUI7AAHu4JogcGI818.jpg "style=" float: none; "Title=" 07 Extended properties. png "alt=" wkiol1vaiavrrui7aahu4jogcgi818.jpg "/>

10.2.8 Database Properties-"mirroring" and "Transaction log Shipping"

The mirroring and transaction log shipping tabs are used to configure or modify the properties of database mirroring and transaction log shipping.

This article from "SQLServer2014 series" blog, declined reprint!

10.2 Properties of the database