[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 519
  • Last Modified:

SQL 2005 instance

I have a database called 'abc' on server A, which is backed up full then restored to server B overnight so that our developer can utilize the database on server B for testing purpose. Both server A and B are very old, so I need to replace.

Instead of having two SQL servers, I'm thinking of having two instances on new single server. Will two instances give any trouble?
0
crcsupport
Asked:
crcsupport
3 Solutions
 
Vijaya Reddy Pinnapa ReddyCommented:
Check the following thread for more infomration for best practices on multiple sql server instances on single server.

http://ask.sqlservercentral.com/questions/6574/best-practise-on-multiple-sql-server-instance-inst.html
0
 
crcsupportAuthor Commented:
This link doesn't answer my question. The database name will be the same but on different instances, one for production, one for testing environment.
I want to make sure the two complete database runs on different instances, does't create any problem, conflict.
0
 
Peter KipropCommented:
Hi  crcsupport,

Yes you can have multiple instance running on a single server. Though there is maximum no if instances you have on a single server /PC..

You can have one default and multiple named instance. Just giving server name would allow you to connect to the default and servernameamed_instance would allow you to connect to named instance.

You can have the same database names on each instance and be able to restore from one instance to the other.

Also note Using multiple instances is acceptable if you have enough resources available.

Hope this helps,

Pthepebble.
0
 
Jim P.Commented:
That can work.

The issue I would worry about is that a developer damaging/altering/modifying a production database by accident.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now