| Author |
Topic |
|
fjudzon
Starting Member
19 Posts |
 Posted - 2010-11-10 : 09:34:12
|
| Hi! I need to create a copy of my database in the same server but I need to have both (or more than 2 perhaps)with the same name.Is that possible? How could I do that?Using DB Instances could help?THanks! |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-11-10 : 10:01:27
|
| No, you cannot have two databases on the same instance with the same name. You can install a named instance, but that's a separate SQL server.--Gail ShawSQL Server MVP |
 |
|
|
fjudzon
Starting Member
19 Posts |
Posted - 2010-11-10 : 10:45:26
|
quote:
Originally posted by GilaMonster
No, you cannot have two databases on the same instance with the same name. You can install a named instance, but that's a separate SQL server.--Gail ShawSQL Server MVP
No, Im not saying to install both in the same instance, I said if it could help to instal each one in a different instance. Is any problem if I do that? Thanks! |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-11-10 : 11:10:30
|
| No problem. Just note that you have to install the instance via the SQL installer.What's the point? What are you trying to do?--Gail ShawSQL Server MVP |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-11-10 : 11:29:58
|
| Yes, you can have multiple instances of SQL Server installed on a single server. Each instance can have the same named database with no problem.What you have to be aware of with multiple instances is memory resources. You need to set max memory on each instance so the total allocated memory for all instances does not exceed available memory for the server (minus at least 2 GB for OS).Jeff |
|
|
|
fjudzon
Starting Member
19 Posts |
Posted - 2010-11-10 : 11:39:33
|
quote:
Originally posted by GilaMonster
No problem. Just note that you have to install the instance via the SQL installer.What's the point? What are you trying to do?--Gail ShawSQL Server MVP
Thanks!I have an application that uses a DB called "Blablabla", and now I have 2 different versions of that DB. The thing is that the application only works if the DB name is "Blablabla" (I cant modify its name). So, what Im trying to do (what I need to do) is to have 2 databases with the same name in the same sever |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-11-10 : 15:38:08
|
| Same server meaning same physical machine? Or meaning same name in application connection string?--Gail ShawSQL Server MVP |
|
|
|
fjudzon
Starting Member
19 Posts |
Posted - 2010-11-10 : 15:52:46
|
| Same server meaning same physical machine |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-11-11 : 02:33:46
|
| Then install multiple instances (watch the memory allocation as Jeff mentioned)--Gail ShawSQL Server MVP |
|
|
|
|
Duplicate Database in the same Server