I have windows 2003 SR2 Standard Server running My SQL 2005 SP3

I have a production database lets call it prod I also have a test database
which has the same data and prod1 I would like to have the same database name
on the same sql server this will make my web dev which accesses this database
easier.
Can I have two datebases on the same sql server with the same name? Can I do
this if I create a second instaance? If so I never used a second instance
does any one have the procedure to do so.

Thanks

Tom

TomDefenderHopeful (TomDefenderHopeful (AT) discussions (DOT) microsoft.com) writes:
Within the same instance, the database name must be unique.

Two instances are completely unrelated, so, yes, you have have a database
called Fritz on both instances.

However, I'm not sure that I see the point. Somewhere in the web
application you will need to have a configuration that decides whether you
are working against production or test. If you have two instances, you
will need to change the server name in the connection string. To wit, if
you have a second instance on the same box, it is a named instance and is
addressed as SERVER\INSTANCE.

You simply run SQL Server Setup. It will ask you whether to upgrade an
existing instance or install a new. Don't forget to apply service pack 3
on the new instance.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx