SQL2000 SP4 release date? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL2000 SP4 release date?

Anyone heard anything on SQL2000 SP4 release. We have the Beta and are wondering if anyone knows when they will release the real version.
Microsoft said: soon. Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
"and SP4 scheduled release date is H2 of 2005 (barring any regression). " From my TAM
.. and if you’re interested you can particpate in Beta programme. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Talked to a tech today and they said that it was due to be released on the 29th of April, but there were some hangups but it literally could be released any day…
Good news, then.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
Yep, today would be today. [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br /<a target="_blank" href=http://www.microsoft.com/sql/downloads/2000/sp4.asp>http://www.microsoft.com/sql/downloads/2000/sp4.asp</a><br /><br />MeanOldDBA<br />[email protected]<br /><br />When life gives you a lemon, fire the DBA.
Would it be good to install sp4 or its better to wait this service pack to get settled as i think its beta version.
Plz let me know ur comments before i install it on my integrated server.
It’s not beta anymore. This is the official release. My plan is: 1. Wait a month.
–Come up with a test plan based on fix list.
–Monitor forums and tech news for problems.
2. Test on dev for a couple weeks.
3. Test on QA, UAT, RELEASE for a week.
4. Move to production a week later. I wouldn’t be hasty about moving this directly onto a production system. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
Tha’t new for me.
I mean Derrick plan for SP4.
Same plan with others sp or just for this one?
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
I’ve used that on all the service packs. It saved my job on a couple of the old ones (6.5 and 7.0). I just think it’s good to be diligent and make sure you’ve tested a release like this really well. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
Woha, you have dev, qa, uat and release environments. Your a lucky guy [<img src=’/community/emoticons/emotion-5.gif’ alt=’;)‘ />]
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5 SP4 includes packages for the following SQL Server 2000 components:
Database Components (Download file: SQL2000-KB884525-SP4-x86.EXE)
Update your 32-bit Database components of SQL Server 2000 including Database Engine, Replication, Client Connectivity components and Tools. For additional information, please refer to ReadmeSql2k32Sp4.htm
Analysis Services Components (Download file: SQL2000.AS-KB884525-SP4-x86.EXE):
Update your 32-bit Analysis Services components of SQL Server 2000. For additional information, please refer to ReadmeSql2k32ASp4.htm.
SQL Server 2000 Desktop Engine (MSDE) Components (Download file: SQL2000.MSDE-KB884525-SP4-x86.EXE):
For your 32-bit MSDE components of SQL Server 2000:
Install a new instance of MSDE
Upgrade existing instances of MSDE
Update applications that have consumed merge modules
For additional information, please refer to ReadmeSql2k32DeskSp4.htm
SQL Server 2000 64-bit Components (Download file: SQL2000-KB884525-SP4-ia64.EXE):
Update your 64-bit Database components and 64-bit Analysis Services components of SQL Server 2000. For additional information, please refer to ReadmeSql2k64Sp4.htm
? MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
Thanx Derrick,[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br />As its official release then, ill test it on my development server for couple of<br />weeks as suggested by you.<br />Plz post ur experts comments if u get any problems after installing.[:0]<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by derrickleggett</i><br /><br />It’s not beta anymore. This is the official release. My plan is:<br />1. Wait a month.<br />–Come up with a test plan based on fix list.<br />–Monitor forums and tech news for problems.<br />2. Test on dev for a couple weeks.<br />3. Test on QA, UAT, RELEASE for a week.<br />4. Move to production a week later.<br />I wouldn’t be hasty about moving this directly onto a production system.<br />MeanOldDBA<br />[email protected]<br />When life gives you a lemon, fire the DBA.<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">
[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />] I’ll let everyone know how it goes. I’m hoping all the testing and waiting on other people to "iron it out" will prevent any of them from hitting production.<br /><br />MeanOldDBA<br />[email protected]<br /><br />When life gives you a lemon, fire the DBA.
SQL2K SP4http://www.sql-server-performance.com/absolutenm/templates/?a=168&z=1 is on show now [8D]. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
I tried to install SP4 on a test machine that has 3 instances. As per the instruction I stopped the instance I was upgrading because I wanted to try to avoid a machine restart. (From the Readme "You can reduce the likelihood that you will need to restart your computer after you install Database Components SP4. To reduce this likelihood, stop the services and applications in the preceding list before you run Setup." I installed SP4 but I still had to do a restart. Perhaps this is because I did not stop the other instances? Anyway the restart is not necessarily easy to avoid. I will leave SP4 on the test machine for a few weeks before attempting another server
If it confirms about restart of services then you must follow to avoid any unnecessary errors in future. I don’t see any issues in restarting services as you’re playing on the test environment. WE’ve followed as suggested without any issues. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>