Manually update site database help
So I ran the CU4 updater and it all went fine except for a warning for perform database update. looking at the logs it says along the lines of this: The
EXECUTE permission was denied on the object fnIsPrimary,database CM_LAB, schema dbo
so i figured it was a permissions error so i asked another member of my team to run the update.sql file in the sql management studio and he sent me back this screenshot of results. My question is, is this the expected results, how can I tell the
db was actually upgraded?
April 28th, 2015 5:11pm
It is not supported to do what you have done. You should contact CSS to get support on this issue.
April 28th, 2015 6:12pm
What does the above indicate? What we did was shut down the sccm server and then run this sql file. Perhaps if the sccm server was on it wouldn't have given that screen. Can we just run/try it again? Our SCCM server is on a separate
server from the sccm sql server.
April 29th, 2015 8:57am
As long you didn't receive an error when running the script, it should have been successful and the 0 in the first column is indicative of this. You may still want to reach out to CSS though to confirm as this separate DB update process isn't explicitly
documented anywhere.
April 29th, 2015 9:10am
Whats the best way to get ahold of CSS?
April 29th, 2015 10:24am
It is not supported to do what you have done. You should contact CSS to get support on t
April 29th, 2015 4:35pm
So there is no way to tell if it successfully updated the database? I wasn't the one who ran the update i just provided the guy with the file and he sent me a screenshot which i uploaded of what its output was. I've never ran an update manually
so I wasn't sure what it was supposed to look like.
April 29th, 2015 6:18pm
None of that is explicitly documented in anything publically available. You can certainly open the file and see what it updates though and perform a manual comparison.
CSS is Microsoft Customer Support Services. A quick web search will reveal the correct number for you to call.
April 29th, 2015 6:41pm
So there is no way to tell if it successfully updated the database?
What was displayed on the 'messages' tab?
You could also restore a copy of the pre-CUx-database to another SQL server and run the SQL script again so you can see what's happening.
April 30th, 2015 2:33am
I'm not sure what was on the messages tab. I don't think he ever looked. Say hypothetically it didn't upgrade the database. What ramifications would that have to sccm if we just kept using it until the next cu comes out? Not that I would like to do that
but it would be simpler just to make sure and run the next cu update as a user who has sysadmin rights on SQL to avoid having to manually do it.
April 30th, 2015 8:03am
Any ideas on what ramifications would that have to sccm if we just kept using it until the next cu comes out?
May 6th, 2015 4:44pm
Don't know. If the update didn't take, then you'd be unsupported and all kinds of weird things could break.
CU5 just came out yesterday though and SP1 for R2 will be out next week (this may be referred to as SP2 in some place --- it's the same t
May 7th, 2015 6:50pm
Great, Ill just update to SP1 for R2 and see how that goes and make sure I am using an account that has the proper permissions. I'm pretty sure the update took it just cant verify it. We haven't had any issues thus far.
-
Marked as answer by
ventura_techtvman
18 hours 43 minutes ago
May 8th, 2015 9:01am
Great, Ill just update to SP1 for R2 and see how that goes and make sure I am using an account that has the proper permissions. I'm pretty sure the update took it just cant verify it. We haven't had any issues thus far.
-
Marked as answer by
ventura_techtvman
Friday, May 08, 2015 1:00 PM
May 8th, 2015 1:00pm