In place SQL 2008 upgrade vs. Side by side?

Posted by Jim on Server Fault See other posts from Server Fault or by Jim
Published on 2010-04-21T12:48:43Z Indexed on 2010/04/21 12:53 UTC
Read the original article Hit count: 210

Filed under:

sql2008

|

upgrade

|

sidebyside

|

Snapshot

I have a SQL 2005 Std edition server with 5 databases in production, 4 db's are used by web-based apps the 5th is a desktop application. My question is should I perform an in-place upgrade or a side-by-side by creating an sql2008 instance on the same box?

The machine is a VM on vmware and I'm planning on taking a snapshot before the upgrade and having a 'blackout' window during the upgrade so that I could roll back to the snapshot if things go really bad.

Any previous experience and advice is appreciated.

© Server Fault or respective owner

Related posts about sql2008

Problem using SQLDMO/Vb6 against SQL2008

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a client, that uses SQLDMO for a portion of a custom application that was written against SQL 2000, and they recently upgraded to SQL2008. The majority of the app still runs fine (doesn't use SQLDMO), but the admin functions which rely on SQLDMO stopped working. I installed the SQL2005 backward… >>> More
Distance Algorithm used in SQL2008 for Geography Data Types

as seen on Stack Overflow - Search for 'Stack Overflow'
I am wanting to know what Algorithm SQL2008 uses when computing distance on Geography Data Types. There are several such Algorithms as the Haversine and Vincenty, however I have found no references for what SQL2008 is actaully using. >>> More
Hello it’s your server calling

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
This is nothing exciting but I've always found this startup procedure very useful. All this simple procedure does is send you an email if the SQL Service Starts. If your Server is a cluster it will tell you which node you're on. -- On it's own this procedure can't actually be… >>> More
Parsing Extended Events xml_deadlock_report

as seen on SQL Blog - Search for 'SQL Blog'
Jonathan Kehayias and Paul Randall posted more than a year ago great articles on how to monitor historical deadlocks using Extended Events system_health default trace. Both tried to fix on the fly the bug in xml output that caused failures in xml validation. Today I've found out that their version… >>> More
Cursors 1 Sets 0

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
I had an interesting experience with a database I essentially know nothing about. On the server is a database which stores session state, Microsoft provide the code/database with their dot net, so I'm told. Anyway this database has sat happily on the production server for the past 4 years I guess… >>> More

Related posts about upgrade

How can I upgrade Vista Home to Vista Ultimate without Anytime Upgrade DVD

as seen on Super User - Search for 'Super User'
Hi, I'd like to upgrade Vista home to vista Ultimate on my desktop computer. I have a MSDN subscription, which means I can download just about every microsoft software there is. However, there doesn't seem to be any vista anytime upgrade DVD available in the MSDN downloads section. Is there any… >>> More
Upgrade to Win7 with upgrade key and full disc

as seen on Super User - Search for 'Super User'
I just ordered a retail copy of Windows 7 Professional Upgrade to finally upgrade my work computer from Vista. It's not scheduled to be delivered until Monday, though, and I was hoping to take my computer home and upgrade over the weekend. I already have a full retail (non-upgrade) disc for the same… >>> More
Windows 7 Home Premium Family Pack upgrade + Windows Anytime Upgrade to Ultimate

as seen on Super User - Search for 'Super User'
Is an install of Windows 7 Home Premium Family Pack license upgradeable? Suppose I'm able to install Windows 7 Home Premium on my computer using a Family Pack key. Would I then be able to upgrade to Windows 7 Ultimate using the Anytime Upgrade option? Considering that the Family Pack only uses one… >>> More
How to Upgrade Your Netbook to Windows 7 Home Premium

as seen on How to geek - Search for 'How to geek'
Would you like more features and flash in Windows on your netbook? Here’s how you can easily upgrade your netbook to Windows 7 Home Premium the easy way. Most new netbooks today ship with Windows 7 Starter, which is the cheapest edition of Windows 7. It is fine for many computing tasks… >>> More
Upgrade Your Existing BI Publisher 11g (11.1.1.3) to 11.1.1.5

as seen on Oracle Blogs - Search for 'Oracle Blogs'
It’s already more than a month now since BI Publisher 11.1.1.5 was released at beginning of May. Have you already tried out many of the great new features? If you are already running on the first version of BI Publisher 11g (11.1.1.3) you might wonder how to upgrade the existing BI Publisher to the… >>> More