Home / server / Questions / 65330
Accepted
Greg Buehler
Asked: 2009-09-15 13:31:04 +0800 CST

SQL Server 2005 update only updates one instance

  • 772

I am currently in the process of performing updates on a SQL Server. Our SQL Server contains two databases, lets call them \\smyqlserver\$database1 and \\mysqlserver\$database2.

I perform the first hotfix and the installer ends reporting successful installation. However, upon attemping the next hotfix in the sequence, it fails due to \\mysqlserver\$database1 possessing the correct version (4211) while reporting that \\mysqlserver\$database2 is still at the initial version (4035)

Wouldn't the hotfix update both instances at the same time?

sql-server

2 Answers

  1. Best Answer

    Nope, they typically only do one instance at a time. There are definitely times when you wouldn't want to do all instances at once. What hotfix are you installing?

    • 1

  2. Each service pack and hotfix need to be applied to each instance independently of each other.

    • 0