To create a database
- In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance
- Right-click Databases, and then click New Database.
- In New Database, enter a database name.
- To create the database by accepting all default values, click OK; otherwise, continue with the following optional steps.
- To change the owner name, click (…) to select another owner.
The Use
full-text indexing option is always checked and dimmed because, beginning in
SQL Server 2008, all user databases are full-text enabled.
|
- To change the default values of the primary data and transaction log files, in the Database files grid, click the appropriate cell and enter the new value..
- To change the collation of the database, select the Options page, and then select a collation from the list.
- To change the recovery model, select the Options page and select a recovery model from the list.
- To change database options, select the Options page, and then modify the database options. For a description of each option, .
- To add a new filegroup, click the Filegroups page. Click Add and then enter the values for the filegroup.
- To add an extended property to the database, select the Extended Properties page.
- In the Name column, enter a name for the extended property.
- In the Value column, enter the extended property text. For example, one or more statements that describe the database.
- To create the database, click OK.
Comments
Post a Comment