Post reply

SQL 2K SP4 Upgrade

  • March 27, 2007 at 5:02 am

    #63056

    I am upgrading to SQL 2K SP4 from SQL 2K SP3 tonight and just want to know of any gotya's.

    I am going to wait for a transaction log back-up to finish before I start the upgrade (I do a full back-up every night and transaction logs every 2 hours), so I am happy that I can get the data back in event of a failure but any advice or experience of problems would be greatly recieved.

    Thanks in advance

  • March 27, 2007 at 6:21 am

    #697109

    Mark

    Are you doing this on a production sever?  Have you tested it first?

    There are certain things to look out for.  For instance, I think SP4 limits the pairs of data types between which implicit conversions can be made.  And it "breaks" AWE as well, so if you are using more than 4GB then you may have to apply a post-SP4 hotfix.  But all these things are documented on this site and elsewhere, so do a search and make a note of anything that might apply to you.

    John

  • March 27, 2007 at 6:54 am

    #697121

    Thanks John

    I am running this on a production server, I have run SP4 on a different server, and checked the Db's on the upgraded server so I am happy that they are all compliant (I had checked with the application suppliers but wanted to check anyway )

    I'm not running AWE so not an issue for me, I am aware that because I'm using mixed mode authentication that the sa password will be put into some of the log files so I will run Killpwd.exe after the installation, to sort that.

    I have had a search on here and can't find anything that is going to cause me a problem, just wanted to get the benefit of anyone elses experience with upgrading from SP3 to SP4.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply