3

I have a SQL Server 2008 R2 that's running as default instance. This instance has been patched with SP1 earlier this year.

I would like to create a new instance for a new application. Once the installation for the new instance is completed, do I need to re-run the service pack installer again?

user9517
  • 117,122
Gostan Balik
  • 33

2 Answers2

3

Yes. Service pack installs (and ultimately MSSQL Server versions) are per-instance.

Hyppy
  • 15,814
1

Yes you should but maybe this wil help? Btw I'm always curious why anybody wants to use multiple instances because from a maintenance point of view its fare from ideal. Good luck!

Joost Verdaasdonk
  • 481