Home > SQL Server, SQL Server 2008 > Creating a new database in Microsoft SQL Server 2008 R2

Creating a new database in Microsoft SQL Server 2008 R2

In this post, I’ll be guiding you how to create your first database with Microsoft SQL Server 2008 R2. For this demo, I’ll be using Microsoft SQL Server 2008 R2 Express Edition.

First, you have to download and install Microsoft SQL Server 2008 R2 Express Edition. You can either download the 32-bit version or the 64-bit version. [ Download here ]

*NOTE: Download the version with Management Tools.

 

After you have completed your download and installed in on your PC, lets get started.

  1. Click start, and search for “SQL Server Management Studio” and run the program.
  2. You will now be prompt to login into your Database Engine. Depending on what type of login method you specified during the installation, you can either logon using Windows Authentication or SQL Server Authentication. In my case, I’ll be using Windows Authentication.
    01-ConnectToDatabaseEngine
  3. After you have successfully logged in, click on “Databases” to see all your existing Databases. If this is your fresh installation, you will only be able to see “System Databases” folder there.
    02-ListOfExistingDatabase
  4. Now, to create your own database, Right-Click on “Databases” on the left column, and select “New Database..”. Then, you should see a pop-up window to create a new database.
    03-CreateNewDatabase2
  5. Enter your database name. For our case now, we’ll just leave other settings with the default values. If you already have some experience with Microsoft SQL Server, you can proceed to do your preferred settings. Hit “OK” after you have done all your settings and you’ll see your database listed on the left panel under “Databases”.
    03-CreateNewDatabase3
  6. Now, let’s see what do we have in our new database here by clicking on the “+” icon on the left panel next to our database name. You should be able to see 8 different types of folders, such as “Database Diagrams”, “Tables”, and etc.

And that’s it. You have just created a new database with Microsoft SQL Server 2008 R2.

Additional:

If you’re wondering where is your database file located in your PC, by default it’s located in:

C:\Program Files\Microsoft SQL Server\MSSQL10.1SQLEXPRESS\MSSQL\DATA

Advertisements
  1. No comments yet.
  1. October 31, 2010 at 12:22 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: