|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
17/07/2008, 18h22
|
#1 |
Messages: n/a
Hébergeur: |
Same db name
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 |
|
|
17/07/2008, 19h17
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: Same db name
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 On Thu, 17 Jul 2008 11:22:31 -0500, "David C" <dlchase@lifetimeinc.com> wrote: >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 > |
|
|
|
17/07/2008, 20h44
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: Same db name
Can you change a setup with Default instance to allow multiples? Or does
that require a complete re-install of SQL Server? Thanks. David "Denny Cherry" <mrdenny.nospam@mrdenny.com> wrote in message news:vivu741esql76uqgr8oau89gdjpmno4h1q@4ax.com... > 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 > > On Thu, 17 Jul 2008 11:22:31 -0500, "David C" > <dlchase@lifetimeinc.com> wrote: > >>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 >> |
|
|
|
17/07/2008, 20h51
|
#4 |
|
Messages: n/a
Hébergeur: |
Re: Same db name
Each instance needs to be installed separately by running the
installer once for each instance. Denny On Thu, 17 Jul 2008 13:44:12 -0500, "David C" <dlchase@lifetimeinc.com> wrote: >Can you change a setup with Default instance to allow multiples? Or does >that require a complete re-install of SQL Server? Thanks. > >David >"Denny Cherry" <mrdenny.nospam@mrdenny.com> wrote in message >news:vivu741esql76uqgr8oau89gdjpmno4h1q@4ax.com.. . >> 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 >> >> On Thu, 17 Jul 2008 11:22:31 -0500, "David C" >> <dlchase@lifetimeinc.com> wrote: >> >>>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 >>> > |
|
|
 |
| Outils de la discussion | |
|
|
