September 22, 2014 at 11:54 am
Hi
I have 1 question:
Can upgrade be done while the system is still Live? I mean production servers are up and running and upgrade is happening? or is it advisable to get a downtime, stop traffic and then carry out upgrade? what can be the negative impacts. pls put link to some relevant article if you have?
thx
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
September 22, 2014 at 3:29 pm
If you perform an in-place upgrade then no, the instance of SQL Server will be taken offline for the duration of the upgrade. I would not recommend this approach as it is quite risky as it can be difficult to rollback.
I would perform a side-by-side upgrade, meaning that I would build a new server, install SQL Server 2008 R2 (if you really have to go to 2008 R2, instead of 2012/2014) and then migrate the databases into the new server.
However there will still be downtime required when moving the databases.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply