The Business Intelligence Blog

November 12, 2009

SQL Server in-place vs side-by-side upgrade

Filed under: SQL Server Database — Tags: , , , , — Shahfaisal @ 11:46 pm

In an in-place upgrade, you stick in a CD, run the setup file and choose the upgrade option. The setup program will automatically upgrade older version of SQL Server to the new version and the older instance of SQL Server is replaced.

In a side-by-side upgrade, you install a separate instance of SQL Server(either on the same box or on a different one) and then move all the content(Databases, users/logins, etc) from the the older instance of SQL Server to the new instance.

What’s the best method to use for upgrade: Well, there is no “best” method, there is however, a “right” method. If you don’t have a separate hardware for a clean SQL Server 2008 install or if you can’t afford to install SQL Server 2008 as a separate instance on your current production box due to performance issues, your only option is to perform an in-place upgrade. Please note that an in-place upgrade is an all-or-nothing approach and so is more risky than a side-by-side upgrade. However, if you have a separate server, a separate clean install would always be better as it will not affect the current production instance (there by providing greater availability) and you will have plenty of time to test your stuff before going live with the new version.

Note: Regardless of which method you choose to upgrade, be sure to run Upgrade Adviser to find out the bottlenecks that might affect your upgrade. It also provides links to documentation that will help you resolve any issue that you might come across during upgrade. Download upgrade adviser here

Advertisements

2 Comments »

  1. […] an in-place upgrade or a side-by-side upgrade? <font face="Verdana"Please refer SQL Server in-place vs side-by-side upgrade for more […]

    Pingback by SQL Server Database Administration – FAQs « The Business Intelligence Blog — January 16, 2010 @ 5:08 am

  2. […] Which is the best method to upgrade, an in-place upgrade or a side-by-side upgrade? Please refer SQL Server in-place vs side-by-side upgrade for more […]

    Pingback by SQL Server 2008 Upgrade – FAQs « The Business Intelligence Blog — January 16, 2010 @ 11:58 pm


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: