Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

When upgrading we normally create a new install and migrate databases over, but we are going to test out in-place upgrade from sql server 2008 to sql server 2008 r2 (standard) in our development environment. Question is can the upgrade steps for in-place be run without downtime or restricting access to the server? Users must be able to continue to work without issues. The purpose of this is to be a test run for a production upgrade. Should in-place be attempted in a production environment where users must be able to access the databases?

Thanks ahead of time.

share|improve this question

2 Answers 2

up vote 2 down vote accepted

An in-place upgrade will stop SQL Server services so there will be interruption of services. I personally prefer to do a clean install such as you say you normally do. The downtime is minimized if you build your new server, detach the databases from the old, bring the new server up, then reattach the databases on the new server. Be sure you're bringing everything (logins, jobs, etc) over before making that swap.

share|improve this answer

Upgrading from SQL 2008 to SQL 2008 R2 in a non-clustered system will require some downtime. If your production database is clustered you can do this as a rolling upgrade with minimal downtime.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.