preview

Nt1330 Unit 1 Assignment 1 Summary

Decent Essays

Summary
For the creation of the first database HandsOnOne in a new Query Editor window, first, I went to the SQL Server Management Studio in the program menu and make sure to connect to the named instance SQLSERVERHOA. After the successful connection to the named instance, I went to the Object Explorer and right clicked on the database and select New Database. I typed the new Database name HandsOnOne and made the update in Autogrowth and initial size column as Data file initial size: 40 MB, Log file initial size: 15 MB, Autogrowth enabled with 15 MB in file growth, and Unlimited maximum file size as shown above in screen shot # 1.
Second, I created the new second database HandsOnTwo by generating the CREATE DATBASE script from the first database HandsOnOne. For this, first I copied the whole create script from the Query Editor window and paste it on a notepad changed the name of the database in the SQL script to HandsOnTwo from HandsOnOne by using the find and replace all command in notepad including the modification of the data file initial size to 35 MB and pasted it back to the Query Editor window and executed the script. The script ran successful and the second new database was created successfully as shown in the screenshot #2 &3. …show more content…

Similarly, I repeated the same steps on second database HandsOnTwo and choose Simple on the Recovery model drop down list as shown in screenshot

Get Access