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 |
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
 Posted - 2007-04-19 : 04:45:52
|
| Not posted here for a while as been stupidly busy, but here goes:This might sound a bit of a silly question, but what issues will I come across with installing a new instance of SQL on top of a single instance setup?The server I have to do this on is currently live on the existing instance and I can't afford any downtime (apart from a 10 minute reboot if rellay required).Thanks |
|
|
SatyaSKJ
Starting Member
46 Posts |
Posted - 2007-04-19 : 06:57:20
|
| Not as I think of any, as we have performed 3 named instances installation on a live server without any issues. You might need to check the service pack levels and if a reboot of server is required then do it during quieter time or agree the downtime for that application.One piece of note is to use min and max settings for memory, otherwise you will see lot of performance issues when all are running at the same time.Satya SKJSQL Server MVPhttp://www.sqlserver-qa.net |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-04-19 : 09:40:26
|
| Thanks |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-04-20 : 09:01:06
|
| Further, you can even install it remotely.RegardsParesh MotiwalaBoston, USA |
|
|
|
|
|
|
Installing a new instance?