May 20, 2010 at 6:10 pm
Hello, All:
We have SQL Server 2005 SP2 on Win 2003, 64bit. There will be a maintenance this weekend that SP4 will be installed.
Could you share the experience please, any risk?
Thanks.
ZYT
May 20, 2010 at 6:19 pm
SP4 for the OS or for SQL 2005?
According to the SQL Server site at Microsoft, only SP3 is available.
http://msdn.microsoft.com/en-us/sqlserver/bb671254.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2010 at 6:24 pm
Sorry to think about SQL Server 2000, Yes, SP3 of SQL Server 2005. Any advice please?
May 20, 2010 at 7:40 pm
Pretty straight forward.
Backup user and system databases.
Run the SP executable
Test your apps.
You should apply the sp in dev or qa long before trying to update a production system as well.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply