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?
DanNetwork EngineerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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:

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.
DanNetwork EngineerAuthor Commented:
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)

Recovery (SharePoint Foundation 2010)
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

DanNetwork EngineerAuthor Commented:
Thanks, I did perform a full backup of the farm today, just in case.
Good idea. :)
DanNetwork EngineerAuthor Commented:
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?
DanNetwork EngineerAuthor Commented:
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.
DanNetwork EngineerAuthor Commented:
so what exactly does the sharepoint products configuration do?
DanNetwork EngineerAuthor Commented:
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
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.
DanNetwork EngineerAuthor Commented:
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. :)
DanNetwork EngineerAuthor Commented:
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.
DanNetwork EngineerAuthor Commented:
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. ;)
DanNetwork EngineerAuthor Commented:
I ran the SharePoint Configuration Wizard, but I still get the same 3 errors.  I've attached the screenshot. sharepoint errors
Try running the command line interface with the force flag:

psconfig.exe -cmd upgrade -inplace -force
Sorry, I was slightly off on the command:

psconfig -cmd upgrade -inplace b2b -wait -force

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DanNetwork EngineerAuthor Commented:
I just processed the command now, so it's thinking, doing it's thing.
DanNetwork EngineerAuthor Commented:
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.
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.
DanNetwork EngineerAuthor Commented:
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!
DanNetwork EngineerAuthor Commented:
This did the trick, this fixed it, and then when it finished, you have to reanalyze the system, but this error message went away!!!!

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.