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
DanNetwork EngineerAsked:
Who is Participating?
 
jessc7Commented:
Sorry, I was slightly off on the command:

psconfig -cmd upgrade -inplace b2b -wait -force
0
 
jessc7Commented:
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:

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/MS-SharePoint/Q_27378073.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.
0
 
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?
0
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
jessc7Commented:
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
0
 
DanNetwork EngineerAuthor Commented:
Thanks, I did perform a full backup of the farm today, just in case.
0
 
jessc7Commented:
Good idea. :)
0
 
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.
0
 
jessc7Commented:
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?
0
 
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?
0
 
jessc7Commented:
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.
0
 
DanNetwork EngineerAuthor Commented:
so what exactly does the sharepoint products configuration do?
0
 
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"
0
 
jessc7Commented:
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/
0
 
jessc7Commented:
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.
0
 
DanNetwork EngineerAuthor Commented:
I have the foundations 2010, not the sharepoint server 2010.
0
 
jessc7Commented:
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. :)
0
 
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.
0
 
jessc7Commented:
That's fine. Same thing - just you don't have any parameters you have to manage when using the GUI.
0
 
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.



0
 
jessc7Commented:
Yes, and I posted on the others. ;)
0
 
DanNetwork EngineerAuthor Commented:
I ran the SharePoint Configuration Wizard, but I still get the same 3 errors.  I've attached the screenshot. sharepoint errors
0
 
jessc7Commented:
Try running the command line interface with the force flag:

psconfig.exe -cmd upgrade -inplace -force
0
 
DanNetwork EngineerAuthor Commented:
I just processed the command now, so it's thinking, doing it's thing.
0
 
jessc7Commented:
OK
0
 
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.
sharepoint.png
0
 
jessc7Commented:
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.
0
 
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.
0
 
jessc7Commented:
Sounds good!
0
 
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!!!!

Thanks,!!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.