August 4, 2014 at 1:53 pm
Hi,
My sql server is 2005 RTM, I want to install service pack 4, but i need to know how long it takes approximately so I can perform this task in the least disturbing time slot.
Do you have any idea?
August 4, 2014 at 8:09 pm
It would depend on your hardware, instance etc, but from memory it takes at least 15 minutes (with antivirus disabled), up to 30 minutes depending on the machine. You would have to schedule at least double with the business to allow for rolling back due to any errors.
August 5, 2014 at 10:47 am
It depends like the last post stated. You should have a Non Production system that looks like your production system and run the SP on it first. That will give you a reasonable idea of how long it will take.
August 5, 2014 at 11:00 am
For patches, I like to request enough time to run a full backup as well as enough time to be able to rollback in the event of failure.
And then pad the outage window to make sure you have breathing room for the upgrade.
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