Post reply

SQL Server 2000 SP4

  • August 16, 2011 at 5:55 am

    #255663

    Hello Guys.

    I've just started as a SQL Server DBA (I've been a developer until now) and one of my first tasks is to upgrade all the companies SQL Server 2000 instances to SQL Server 2008.

    Unfortunately some of our instances of SQL Server 2000 have not had SP4 applied so I'll have to do that first before anything else. I have noticed that there are several security updates that can be downloaded after installing SP4 but I'm concerned about which ones I need. Do I need to apply them all or do I only need to apply the latest?

    Any help you could provide would be most appreciated.

    Andrew

  • August 16, 2011 at 6:02 am

    #1369023

    I googled and didn't find anything definitive that said you had to upgrade to SP4 prior to upgrading to 2008...where did you see that?

    my recommendation would be only if it is manditory, then only install SP4, then upgrade to 2008.

    the security upgrades would be more specific to SQL 2000 specifically; the items they address would be redundantly fixed in higher versions, if they apply.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 16, 2011 at 6:04 am

    #1369027

    Andrew

    If you're going to upgrade to SQL Server 2008 straight away, then just get your servers to a position where they can be upgraded. If that's SP4, then just apply that and do the upgrade. Once the upgrade is done, don't forget to apply the latest patches regularly to SQL Server.

    John

  • August 16, 2011 at 6:29 am

    #1369035

    Thanks for the response guys.

    The supported upgrade paths for SQL Server 2008 at http://msdn.microsoft.com/en-us/library/ms143393.aspx show that SQL Server 2000 needs SP4 applied.

    In an ideal world I'd like to apply SP4 and then upgrade to 2008 straight away but just in case that doesn't happen, do you guys know what security patch(es) I should apply?

    Thank you,

    Andrew

  • August 16, 2011 at 12:30 pm

    #1369258

    That would be for an in-place upgrade.

    I would recommend installing fresh instances of SQL 2008 on new servers and migrating the databases over. You will encounter less headaches this way. In-place upgrades are more error prone.

    Adam Durr
    Remote DBA support
    www.bluegecko.net

  • August 17, 2011 at 1:53 am

    #1369456

    Thank you Adam.

    I think that's the way forward however I cannot guarantee that SQL Server 2008 will be available for me install as a separate instance. I'm really just trying to cover all eventualities and make sure that if it is not available, our instances of SQL Server 2000 have all the necessary updates,

    Regards,

    Andrew

  • August 18, 2011 at 10:07 am

    #1370237

    All you need to do is get them up to pre-upgrade stage.

    Upgrade to SQl 2008

    And then get the download patches for the updates

    they will be relevant to SQL 2008 and not SQl 2000 , this was your getting the job done as fast as possible,

    cheers

    matt

Viewing 7 posts - 1 through 6 (of 6 total)

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