>Hi.
>We have a Production Sql Server Express running...working fine.
>One of our software partners who use the Tbales has asked us to set up another instance of
> Sql Server Express running on same machine so they can do some testing.
>My immediate reaction was just to copy the Database but they said thye wanted a diferent
> instance running.
>Is this possible and how would I go about setting up anothe rinstance ?
>Does Sql Express have to be installed a second time ?

Yes, you can install multiple instances of various editions of SQL Server on a single box. You do have to go through the installation process again (and apply any necessary updates and patches).

At some point in the installation process you're asked to supply a server name (i.e. instance name). It pays to make it something meaningful e.g. SSX_Testing.

If you're not using it already, SQL Server Management Studio Express can be freely downloaded from http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

This makes various maintenance tasks easy e.g. back up database to a file, then restore from the file to the new instance.