Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Automating SQL Server Service Pack / Patch / H

Author  Topic 

ssivaprasad
Starting Member

9 Posts

Posted - 2005-10-12 : 22:18:23
In one of my task I have to apply the latest SQL Server Service Pack / Patch / Hot fix on all the SQL Server Boxes in our client environment. There are more than 400 SQL Server boxes with SQL Server version 6.5, 7.0 and 2000 running on Window NT, 2000 and 2003 Platforms. We have been given deadline of one month to apply the SQL Server patches access all the box.

It is also being advised to rollout this task Quarterly on every year as the Service pack / Patch are being released.

Hereby I am looking for some advise on

1. The best process to follow on for this task:

2. Automating this task:
Is anyone used any third party tools like "Opsware" to automate this process?


3. Issues and Risks:
Issues and Risks which to be faced as part of this task .


4. Misc:
Any sort of information that would help with this task.
   

- Advertisement -