Database server upgrade


Currently, i am using SQL SERVER 2008 Standard in our organisation. I wonder what factors should i consider to upgrade it to sql server 2008 r2? In other words, what factors drive in an organisation that enables us to think about upgrading a existing version of the database server.


more ▼

asked Nov 16, 2011 at 06:42 PM in Default

avatar image

Katie 1
1.4k 132 164 205

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Regardless of the version you want to upgrade to, take a look at what features you currently use and what features are coming in the version you want to upgrade to. Take into consideration if there are any features that you currently miss, but are in the next version. Also consider if the Edition will stay the same or not (upgrade/downgrade).

Some Enterprise only features of a current version get pushed down to Standard Edition (backup compression being a good example for 2008R2).

I agree with @Håkan Winther, wait and upgrade to 2012. That is, if you can wait and if the new licensing plans don't clash with your company's policies.

more ▼

answered Nov 16, 2011 at 11:46 PM

avatar image

26.2k 18 37 48

@william and how does the licencing work, is there a chance, you give me some ballpark figure of the cost involved in an upgrade? I know i should be calling microsoft. But trying to get a sense of the money involved the effort, if you had any experience doing it.

Nov 17, 2011 at 04:51 AM Katie 1

I'm afraid that is a difficult subject. I work for a large company with a licensing contract with MS, so we pay different prices compared to other companies.

If you don't have a contract with MS, you would need to speak to them directly or look at pricing from 3rd party resellers.

Nov 17, 2011 at 05:01 AM WilliamD

Brent Ozar and Denny Cherry have some good articles on the pricing changes.

Nov 17, 2011 at 06:35 AM Shawn_Melton

@Shawn_Melton - there is no doubt some great info out there on the upcoming pricing changes with 2012. However, not everything there will be applicable to everyone. MS pricing policies are a mess at best. There are multiple possible prices for the same product, depending upon your/your company's affiliation/contracts with MS.

With that in mind, @Katie 1 is probably best off talking to an MS representative about what is possible and what it will cost.

Nov 17, 2011 at 06:40 AM WilliamD
(comments are locked)
10|1200 characters needed characters left

Personally I would wait for SQL server 2012. SQL server 2012 contains a lot more features that are useful and SQL server 2012 is scheduled to the beginning of 2012.

more ▼

answered Nov 16, 2011 at 09:41 PM

avatar image

Håkan Winther
16.6k 37 46 58

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Nov 16, 2011 at 06:42 PM

Seen: 1278 times

Last Updated: Nov 16, 2011 at 06:42 PM

Copyright 2018 Redgate Software. Privacy Policy