Post reply

Service Pack

  • March 9, 2009 at 10:38 am

    #135281

    My version of sql server.

    9.00.1399.06RTMEnterprise Edition (64-bit)

    I understand rtm stands for released to manufacturing but hwats does it mean. is this same as SP2.

    As per my version doeas it mean its SP2 ?

  • March 9, 2009 at 10:57 am

    #956216

    NO. It means you haven't had any service packs or updates applied to your current installation of SQL Server 2005.

    I suggest that you look into getting your system updated.

  • March 9, 2009 at 11:16 am

    #956231

    can i update sp3 directly without sp1,sp2.

    thanks

  • March 9, 2009 at 11:18 am

    #956232

    Yes

  • March 9, 2009 at 11:27 am

    #956237

    once installed does the server need reboot?

    how safe is this installation and are there any precautions to be taken.

    thanks

  • March 9, 2009 at 11:30 am

    #956240

    SQLServer2005SP3-KB955706-IA64-ENU.exe

    SQLServer2005SP3-KB955706-x64-ENU.exe

    SQLServer2005SP3-KB955706-x86-ENU.exe

    out of hte 3 files how do i choose most appropriate for my server.

  • March 9, 2009 at 11:31 am

    #956241

    I'm sorry, would you like me to come to your office and do it for you?

    Yes, there can be issues when you apply the service pack, yes, you might have to reboot the server.

    Do a search on SSC, you'll see that there can be issues. I had an issue with one of my servers.

    Best thing you can do is try it first on a development server, make sure things go as expected.

  • March 9, 2009 at 11:33 am

    #956245

    Hey Mike,

    You need to know which chipset (processors) you are using. x86 is 32-Bit, x64 is 64 Bit and IA64 is the Itanium chipset which I doubt you have as it is rarely used except for the really BIG servers. 🙂

    There is also a good site to help you with the version information which can be found HERE.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • March 9, 2009 at 11:51 am

    #956268

    from select @@version

    Microsoft SQL Server 2005 - 9.00.1399.06 (X64)

    Oct 14 2005 00:35:21 Copyright (c) 1988-2005 Microsoft Corporation

    Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

  • March 9, 2009 at 11:54 am

    #956273

    Mike Levan (3/9/2009)

    from select @@version

    Microsoft SQL Server 2005 - 9.00.1399.06 (X64)

    Oct 14 2005 00:35:21 Copyright (c) 1988-2005 Microsoft Corporation

    Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

    That is your OS not SQL Server 2005.

    This is SQL Server, Microsoft SQL Server 2005 - 9.00.1399.06 (X64) and it is RTM.

    This is your OS, Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2), it is running SP 2 of the OS.

  • March 9, 2009 at 12:01 pm

    #956285

    So, based on your reply, you would need the x64 version of the service pack.

    As Lynn suggested, test prior to rolling this out to production and make sure you follow instructions in the readme file.

    HTH.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Viewing 11 posts - 1 through 10 (of 10 total)

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