Creating databases using SQL Server Management Studio is a standard operation and does not require a deep understanding of computer resources from the user. In this case, SQL Server 2008 R2 is considered.
Instructions
Step 1
Connect to the required instance of SQL Database Engine in Object Explorer and expand the required node of the selected instance. Call the context menu of the "Database" element by clicking the right mouse button and select the "Create database" command. Enter the desired value for the name of the created database in the line "New database" and confirm the application of all default values.
Step 2
Do not try to change the Use Full-Text Indexing setting as this setting cannot be changed and cannot be accessed. Use the field with the symbol (…) to change the name of the owner of the database being created, or select the cell to be edited in the "Database files" table to change the values of the primary data and enter the desired value. Go to the "Parameters" page to edit the sorting configuration of the created database and specify the desired settings in the catalog. Take the opportunity to change the required recovery model or edit the parameters of the database itself on the same page.
Step 3
Select the "Filegroups" page to create a new filegroup and use the "Add" option. Enter the desired values for each added group in the appropriate fields and go to the "Advanced Properties" page to be able to add a nonexistent property to the newly created database. Enter the desired value for the name of the added property in the Name column and type a short description of the created database in the Value column so that you can quickly identify the database to be deployed. Authorize the completion of the creation and deployment of the required database in SQL Server Management Studio by clicking OK.
