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
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
In looking at the message, it's telling me to run this command in the sharepoint management shell, "Upgrade-SPContentDatabase
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
Last Comment
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
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.
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
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"
"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/
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.
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. :)
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.
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.
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. 
Try running the command line interface with the force flag:
psconfig.exe -cmd upgrade -inplace -force
psconfig.exe -cmd upgrade -inplace -force
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
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.
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,!!!!
Thanks,!!!!
Windows Server 2008
Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.
86K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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.