Upgrade 2005 to 2008

Can anyone tell me the potential/frequent issues noticed during upgrade from sql 2005 to 2008 version.

What are the solutions and preventive measures?

Rgds Aj

Matt, Can you please advise,what do you mean by "Make sure your backups are usable first",unabl to add comments via "Add new comment" button,hence posted my comments here.

Matt,thank you for asking, When I click on "Add new comment" button there is no change in the screen,nither I see the comment box where I can input my comments.I am not sure how can I update my comments?

Rgds, Ajit

more ▼

asked Jul 27, 2010 at 12:13 AM in Default

avatar image

830 89 93 95

Ajit - what do you mean about add new comment? Can you describe a bit more about what it says? Because I tested this last week and it was OK - so maybe I'm doing something different?

Jul 27, 2010 at 04:39 AM Matt Whitfield ♦♦

Ajit - Ok thanks - one final question - can you let me know what O/S and Browser you are using?

Thanks again

Jul 28, 2010 at 05:03 AM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

2005 to 2008 is generally a pretty smooth upgrade, but it's worth taking all usual precautions:

  • Make sure your backups are usable first

  • Upgrade side-by-side if possible, rather than in-place

  • Make sure all statistics are updated, ideally take the opportunity to reindex all indices beforehand

  • Make sure you have a backout plan if it all goes pear shaped

This question also has a couple of useful links.

more ▼

answered Jul 27, 2010 at 12:28 AM

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

By "Make sure your backups are usable first", I assume you mean "make sure you can restore from the backup to a new similar server"...

(Clarifying for Ajit...)

Jul 27, 2010 at 02:07 AM ThomasRushton ♦♦

@ThomasRushton - absolutely, yes.

Jul 27, 2010 at 04:37 AM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left

There are a few T-SQL commands that have become deprecated in 2008. One of the big ones is BACKUP LOG WITH NOLOG and BACKUP LOG WITH TRUNCATEONLY no longer works. You can trace for Deprecation Final Support Event in Profiler which will let you know if your using any commands that will not work in 2008.

It's also a very good idea to run the Upgrade Advisor and review the output.

more ▼

answered Jul 27, 2010 at 12:34 AM

avatar image

Nick Kavadias
486 3 5 11

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

Personally, I would always go for upgrading to new hardware / vm. That way, you've got no problems with going back to the previous version.

  • Check your backups anyway

  • Check the database structures (DBCC CheckDB)

  • Matt suggests rebuilding index stats - I would leave that until it's on the new box, assuming that the new box is a more powerful server...

  • Detach the database

  • Copy the database & log files to the new server

  • Reattach on the old server

  • Attach on the new server

  • Side-by-side testing

Backout plan? Well, you've not destroyed anything...

I've prepared a little list of other things to look at when migrating / upgrading on my blog. If you can spot anything missing, let me know!

more ▼

answered Jul 27, 2010 at 02:13 AM

avatar image

ThomasRushton ♦♦
42.3k 20 57 53

(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: Jul 27, 2010 at 12:13 AM

Seen: 1648 times

Last Updated: Jul 28, 2010 at 04:48 AM

Copyright 2018 Redgate Software. Privacy Policy