Install Configure SQL 2005

  • I am getting started installing SQL 2005, now how do I configure SQL, I have opened up SQL Server Configuration, I want to create a database and copy over a copy of our test database to work with. Don't know where to start. I am testing using a vm instance not on a network.

  • Couple of ways to do this.

    1. You can just back up your Test DB and restore it.

    2. Detach TestDB, Copy the physical Files over to the VM instance and attach them.

    3. Use SSMS GUI to create DB's

    4. Use SSMS and use a T-SQL script to Create DB

    -Roy

  • I keep getting that I am not connected to a server, did I miss a step in the install of sql 2005

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply