Start Free Trial

asked on

sharepoint database upgrade problem

I am running sharepoint foundations 2010 and ever since its' been intalled, I keep on getting this attached error message.
In looking at the message, it's telling me to run this command in the sharepoint management shell, "Upgrade-SPContentDatabase ", but I don't know what that will do, will it take down my current site, will all our current documents, link, webpages be unavaialable after the upgrade?
I don't want to start from scratch again, as it's a nightmere, so what's the best way to proceed?
Is there a way I can make a backup of everything currently and if I have to revert back to it, to just use the backup?
sharepointupgrade.doc

It looks like a patch was installed at some point (security fix, Cumulative Update, Service Pack, etc). You could just run the SharePoint Configuration Wizard, which Microsoft recommends running after every update. See here for a couple screenshots to get you going:

https://www.experts-exchange.com/questions/27378073/Sharepoint-schema-issue-after-security-update.html

You will encounter some downtime, as IIS will be restarted, and the databases will be upgraded, so do this off hours, so you don't affect business users.

Your farm should be fine afterwards as this is a standard procedure.

ASKER

The only thing is, I don't have a problem with my shema or anything and I haven't installed any updates. So by following this process, it's not going to break anything, right?

I can't guarantee you won't run into issues, but this is normal procedure, and 95%+ of the time it works just fine. If you get an error, paste it in to EE. I'm sure someone will be able to help.

As a minor tip: I have seen in rare occasions where the process ends with an error, but running it one or two more times resolves the error and it completes just fine. You don't find that in TechNet. :)

You really should have have a backup / recovery plan though. Here is help from TechNet.

Back up a farm (SharePoint Foundation 2010)
http://technet.microsoft.com/en-us/library/ee428295.aspx

Recovery (SharePoint Foundation 2010)
http://technet.microsoft.com/en-us/library/ee748620.aspx

ASKER

Thanks, I did perform a full backup of the farm today, just in case.

Good idea. :)

ASKER

I'll follow the link you mentioned tonight. So do you know how long that will take? My backup is 210 MB currently of the entire farm.

How long the SharePoint Configuration Wizard can take? Sometimes it can take up to 5 - 10 minutes. That's assuming you just have one SharePoint server to upgrade. Is that the case?

ASKER

Yes, just one. So then my sharepoint will be down for 10 min or so. If something happens and it won't come up, I'm assuming I can restore from the backup, right?

Yes. Although I wouldn't rush to the backup. If you get an error, it might be worth doing a little troubleshooting first. Give yourself enough of a window.

If something happens, you could post back here in this question (I would see it) AND also open up a new EE question to get additional attention from other SharePoint experts.

ASKER

so what exactly does the sharepoint products configuration do?

These posts are for SP2007, but hopefully gives you some comfort:

http://www.whatsthepointofsharing.com/tag/sharepoint-configuration-wizard/
http://social.technet.microsoft.com/Forums/en/sharepointadmin/thread/d8fb12c9-9cb7-47f8-8fd2-55730d65f32e

Basically it is a graphical interface for PSConfig:

http://technet.microsoft.com/en-us/library/cc288944.aspx

ASKER

This post is saying to not use it if everything is running smoothly:
"If you have a farm up and running already it's not a good thing to play with, use Central Admin instead"

Here is a graphical walk through using the SharePoint Configuration Wizard after installing SP1 and other updates:

Install SharePoint Server 2010 SP1 with Office Web Apps
http://www.collicott.net/jess/2011/07/10/install-sharepoint-server-2010-sp1-with-office-web-apps/

If you notice, he also says you run it in the case of applying updates, which a database schema qualifies for.

Other than those use cases, yes, leave it alone.

ASKER

I have the foundations 2010, not the sharepoint server 2010.

Foundation is the base of Server. Same steps apply in general. I'm not suggesting you install SP1, just run the Configuration Wizard.

I think I'm giving you too much information and making this more complicated than it is. :)

ASKER

what happens if I just use this command in the management shell?
When looking at the remedy for sharepoint, that's what it's telling me to do.

That's fine. Same thing - just you don't have any parameters you have to manage when using the GUI.

ASKER

i see, so it will perform that command as wel in the background is what your're saying. Great.

How do I fix this issue: "product/patch installation or server upgrade required"?

Or "the server farm account should not be sued for other services"?

I have seperate questions for these open, so if you can help solve these, you can get the pts for all 3 open questions.

Yes, and I posted on the others. ;)

ASKER

I ran the SharePoint Configuration Wizard, but I still get the same 3 errors. I've attached the screenshot.

User generated image

Try running the command line interface with the force flag:

psconfig.exe -cmd upgrade -inplace -force

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

I just processed the command now, so it's thinking, doing it's thing.

OK

ASKER

I've attached the results. It said successful, but when I go to the errors, they are all still there.
It didn't solve any of the problems. I have to leave now, but will be back in the office tomorrow morning.
sharepoint.png

Can you open the warning about the database versions, and see if the list of databases are fewer? I'm wondering if just the content db is left.

ASKER

WAIT, i did a reanalyze, and one of the errors went away, sweeeet!

I still have 2 errors left.
1. is the server farm account should not be used for other services and 2. product/patch installation or server upgrade requried.

Perhaps you can lead me in the right direction tomorrow.

Sounds good!

ASKER

This did the trick, this fixed it, and then when it finished, you have to reanalyze the system, but this error message went away!!!!

Thanks,!!!!