• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 531
  • Last Modified:

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
0
afacts
Asked:
afacts
  • 16
  • 14
1 Solution
 
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
 
afactsAuthor 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
 
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
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
afactsAuthor Commented:
Thanks, I did perform a full backup of the farm today, just in case.
0
 
jessc7Commented:
Good idea. :)
0
 
afactsAuthor 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
 
afactsAuthor 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
 
afactsAuthor Commented:
so what exactly does the sharepoint products configuration do?
0
 
afactsAuthor 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
 
afactsAuthor 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
 
afactsAuthor 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
 
afactsAuthor 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
 
afactsAuthor 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
 
jessc7Commented:
Sorry, I was slightly off on the command:

psconfig -cmd upgrade -inplace b2b -wait -force
0
 
afactsAuthor Commented:
I just processed the command now, so it's thinking, doing it's thing.
0
 
jessc7Commented:
OK
0
 
afactsAuthor 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
 
afactsAuthor 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
 
afactsAuthor 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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 16
  • 14
Tackle projects and never again get stuck behind a technical roadblock.
Join Now