Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Procedure for adding new named instance to production sql server 2008 r2 std. ed. Expand / Collapse
Author
Message
Posted Tuesday, April 29, 2014 12:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 11:41 AM
Points: 35, Visits: 126
Hi
I have a sql server 2008 r2 std. ed. box with only default instance on it.
It is patched to build 4297 (sp2 cu10).
Normally I create an extra named instance when installing the box - but not this time.

Now I need to add an extra named instance on this SQL, which is allready in production.

Will it require a reeboot ?

What about patching ?
Will I have to reapply SP2 and then reapply CU10 ? and when doing so - should I only select the new Instance ?

Post #1565763
Posted Tuesday, April 29, 2014 3:03 AM This worked for the OP Answer marked as solution


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:15 AM
Points: 6,640, Visits: 14,224
jens.riis (4/29/2014)
Will it require a reeboot ?

it might require one before you run the installer if you have a pending reboot.
When installing the new instance it's unlikely to require a reboot afterwards.


jens.riis (4/29/2014)
Will it require a reeboot ?
What about patching ?
Will I have to reapply SP2 and then reapply CU10 ? and when doing so - should I only select the new Instance ?


Yes, you will need to apply the SP and\or CU to the new instance


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1565811
Posted Tuesday, April 29, 2014 3:41 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, September 22, 2014 1:34 PM
Points: 58, Visits: 197
Hi,

to avoid doing the CU you could try slipstreaming the installation

http://blogs.msdn.com/b/petersad/archive/2010/05/31/rrr.aspx
Post #1565818
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse