Same db name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David C - 17 Jul 2008 17:22 GMT

I am using SQL Server 2005 Std Edition. Can I have more than 1 database of
the same name on the same physical server? If so, how can that be done?
Thanks.

David

Reply to this Message

Denny Cherry - 17 Jul 2008 18:17 GMT

Within the same server, yes, provided that each database is attached
within a separate instance of the SQL Server service. If you only
have one instance installed (the default instance for example) then
no, each database name must be unique.

Denny

>I am using SQL Server 2005 Std Edition. Can I have more than 1 database of
>the same name on the same physical server? If so, how can that be done?
>Thanks.
>
>David

Reply to this Message

David C - 17 Jul 2008 19:44 GMT

Can you change a setup with Default instance to allow multiples? Or does
that require a complete re-install of SQL Server? Thanks.

David

> Within the same server, yes, provided that each database is attached
> within a separate instance of the SQL Server service. If you only
[quoted text clipped - 9 lines]
>>
>>David

Reply to this Message

Denny Cherry - 17 Jul 2008 19:51 GMT

Each instance needs to be installed separately by running the
installer once for each instance.

Denny

>Can you change a setup with Default instance to allow multiples? Or does
>that require a complete re-install of SQL Server? Thanks.
[quoted text clipped - 13 lines]
>>>
>>>David

Reply to this Message