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.