Differences between SP2 and SP3 for SQL 2005

We have 2 database servers; one is our production database server and the other is our test database server. I do my best to make sure that the database schema is identical between the two, and in doing so I noticed that the test database server is at service pack 3 for SQL Server 2005, whereas our production database server is at SP2 for SQL Server 2005. When SP3 came out I remember there being some discussion of some changes to some data types (if memory serves), but I don't think there was much in the way of major changes which would likely negatively impact a business environment which does rather run-of-the-mill type of data actions. So, is there really anything I need to worry about, when considering the possibility of moving our production database server to SP3?

more ▼

asked Feb 18, 2010 at 02:38 PM in Default

avatar image

801 48 51 55

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

2 answers: sort voted first

MSDN is the best place to check the details http://msdn.microsoft.com/en-gb/library/dd353312(SQL.90).aspx

more ▼

answered Feb 18, 2010 at 02:52 PM

avatar image

Fatherjack ♦♦
43.8k 79 101 118

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

As well as research like Fatherjack has suggested, the best way to see if a SP has an affect on your system is to apply it to a test server and, well, test. It seems that you may have, even if somewhat by accident than design, already done this as you say your TEST server is on SP3.

Service Packs don't tend to have changes in them like new or removed or fundamentally changed data types - that's more version level - unless there was a bug fix or some other slight change. But that's where testing would come in.

The thing to remember is when you are ready to apply the service pack is backup and verify. And not just your user databases, but system ones (master, model, msdb) too. As Grant says, you can't be paranoid enough.

more ▼

answered Feb 18, 2010 at 04:57 PM

avatar image

Kev Riley ♦♦
66.8k 48 65 81

(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: Feb 18, 2010 at 02:38 PM

Seen: 2561 times

Last Updated: Feb 18, 2010 at 02:38 PM

Copyright 2018 Redgate Software. Privacy Policy