IT Management Suite

  • 1.  Patching Multiple Instances of SQL on Same Server

    Posted Dec 15, 2008 09:09 AM
    We are building a SQL server that will have multiple instances of SQL 2005 installed. Will Altiris patch all instances or will it only patch the default instance?


  • 2.  RE: Patching Multiple Instances of SQL on Same Server

    Posted Dec 15, 2008 11:15 AM
    Well, I'm going by MS08-052 which had a SQL 2005 patch in it; it included a command line switch '/allinstances'. I checked and the KB954606 patch .bat file is using this switch, so I would say "yes", it will patch (or at least try to patch) all instances. I know our Server guys had some trouble with this patch on our SQL boxes, and we had some issues with it patching MSDE/SQL 2005 Express instances too, so YMMV.


  • 3.  RE: Patching Multiple Instances of SQL on Same Server
    Best Answer

    Posted Dec 16, 2008 03:15 AM
    Thanks for the information.

    I checked out several of the SQL patch batch files and found that switch, '/allinstances', where applicable. I would say the answer is as you said; " it will patch (or at least try to patch) all instances." YMMV

    Thanks for your help.