Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

service pack on cluster Expand / Collapse
Posted Wednesday, June 19, 2013 4:10 PM


Group: General Forum Members
Last Login: Yesterday @ 5:16 PM
Points: 1,889, Visits: 3,547
Thanks much,

Post #1465420
Posted Thursday, June 20, 2013 3:40 AM



Group: General Forum Members
Last Login: Today @ 6:00 AM
Points: 7,978, Visits: 16,012
Elliott Whitlow (6/19/2013)
It is my understanding that the system databases get upgraded when SQL starts for the first time with the new (updated) binaries. It can tell internally that the system version of the objects is different. Also in some cases the system objects are unchanged in the database.



In fact, a copy of the MSSQLSystemResource database is now located on each node instead of the shared drive and holds the current version of the installed binaries. This is how SQL Server knows whether to perform a rolling upgrade\downgrade on the instance when it starts.


"Ya can't make an omelette without breaking just a few eggs"
Post #1465543
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse