Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2014-08-27 : 01:24:08
|
| Currently We have default instance and also a Named Instance on SQL Server 2008 R 2.Can I able to create another 3rd Instance? If so how many instances can a SQL Server would allow.Thank You. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-08-27 : 13:12:10
|
| Be careful to apply some capacity planning re: resource usage , disk and file palcement , storage growth etc. There can be many licensing benefits placing multiple instances on one server, but needs to be weighed up against performance\scalability.Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2014-08-27 : 18:29:24
|
| Thanks Peers. |
|
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2014-09-03 : 02:00:24
|
| There exists Log shipping (Second) Server which also needs to get the same Instance being created.Will there be any difference in creation to the primary server.Thanks All. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-09-04 : 01:37:18
|
| You create the instance in the same way , but then you need to configure for Log ShippingJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Instance Creation