I have a SQL Server 2008 R2 server with several instances installed. Is there a way to add a new instance and have it be to the same build as the existing (and updated / patched) instances?
Asked
Active
Viewed 45 times
1 Answers
1
No, unfortunately there is no magic "be like that guy" feature. What you have to do is either:
- install RTM and then apply the SP + CU; or
- slipstream the same SP + CU into the RTM binaries and install that. These instructions are applicable to both SQL Server 2008 and SQL Server 2008 R2, though the process is a little easier in SQL Server 2012.
The former is easier but could require more downtime.
Glorfindel
- 2,205
- 5
- 19
- 26
Aaron Bertrand
- 181,950
- 28
- 405
- 624