Step by step help on creating a local database in SQL Server 2005

Posted on 2009-12-27
Last Modified: 2012-05-08

Can anyone help me create a local server in SQL server 2005? I have SSMS express. I am trying to set up a local database so I can practice writing SQL queries.

Question by:rt2001
    LVL 29

    Expert Comment

    by:Kumaraswamy R
    LVL 51

    Accepted Solution

    Well creating a local server means installing a local instance of SQL Server :

    Now, you will need a license to do that, or, buy SQL Server Development Edition at a hugely reduced price (around $60 USD) and essentially the Enterprise Version, or, get the SQL Express with Advanced Services (contains all kinds of essential goodies) but with Express you do not get SQL Server Agent type goodies (like scheduled maintenance / backups, mail, mirroring and a few other bits). Express is also size constrained but it is free. Have a look at : and to install follow the steps in

    So, first thing to do is to decide what version and then install the most appropriate for your needs. Also, if it is already installed, you could create a new registered server :

    Then to create a database, it is pretty much the same in all version - use SSMS interactively is probably the easiest - it will step you through there is a good tutorial on SSMS (Sql Server Management Studio) on : and to create a database have a read up on  and if using SSMS then see:

    Now the most important thing is to make sure you install Books On Line - that can describe most things above for you, and if you are like me, will use it / refer to it fairly often.


    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now