Creating a Database

Day-2

Creating a database

There are two types of data files: primary and secondary. When a database is initially created, the primary data file is created. By default, it contains all the startup information for the database. As user-defined objects are created, they may also be stored in the primary data file. However, you may implement certain architectural strategies to improve the performance, scalability, and maintainabil­ity of your database.

Ø  Right-click the Databases folder.

Ø  In the context menu, select New Database

Ø  In the Database Name text box, type  “Thigalla” ( Type Database name)

Ø  In the Database Files section, locate the Path column. On the first row under the Path column, click the ellipsis button

Ø  On the same row, under the File Name column, type “Thigalla” ( Type Database name)

Ø  On the second row, under the Path column, click the ellipsis button.

Ø  Click OK. Refresh your Database

Adding files and filegroups

            Right-click the Thigalla database and select Properties

           Select Filegroups from the Select a Page section of the Database Properties dialog box.

       Click the Add button under the Rows section

       In the newly created row, under the Name column, type Thigallagroup1

       In the second row, under the Default column, check the box

Click Add, in the newly created row, under the Logical Name column, enter thigallagoud1

 In the File group column, select Thigallagroup1

       In the File Name column, enter Thigallagoud1.ndf , Click OK.

        

 

Srikanth Goud - Virtualization Administrator