?
Solved

Sharepoint spconfig fails and now SBS2011 will mot back up.

Posted on 2013-05-24
7
Medium Priority
?
632 Views
Last Modified: 2013-06-03
after the sharepoint update I ran spconfig command and it fails on one of the steps.  Now in event viewer there are errors from sharepoint comming up.

one of the errors are event id 3760:::::SQL Database 'WSS_Search_SBS2011' on SQL Server instance 'SBS2011\SHAREPOINT' not found. Additional error information from SQL Server is included below.

Cannot open database "WSS_Search_SBS2011" requested by the login. The login failed.
Login failed for user 'SAMS\spfarm'.


and the other error is event id 6398:::::The Execute method of job definition Microsoft.SharePoint.Search.Administration.SPSearchJobDefinition (ID d4f93fc8-3847-4237-90a0-1d5b6397fa4a) threw an exception. More information is included below.

Cannot open database "WSS_Search_SBS2011" requested by the login. The login failed.
Login failed for user 'SAMS\spfarm'.



whenever i tun the backup it fails when it is trying to run the VSS before it backs up the data.

Im pretty sure the server is not backing up because sharepoint will not update.  Any Ideas
0
Comment
Question by:BBrayton
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 8

Expert Comment

by:PaulD77
ID: 39194128
Give this a shot...
Open the SharePoint management shell..Start, all programs, Microsoft SharePoint 2010 products, mgmnt shell
run the command
(get-spserver $env:servername).NeedsUpgrade  where server name is the name of your machine
If the Value comes back as True, try running the psconfig command.  Follow the details in this article:

http://blogs.technet.com/b/sbs/archive/2011/07/06/potential-issues-after-installing-sharepoint-foundation-2010-sp1.aspx
0
 

Author Comment

by:BBrayton
ID: 39194174
I tried that it does not some up with anything.  it just starts a new command line.
0
 
LVL 8

Expert Comment

by:PaulD77
ID: 39194181
I would run the PSconfig anyway just to force any updates.  The site will go down for a few minutes while it runs
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:BBrayton
ID: 39194182
If I don't put in the computer name and leave the line as default it tells me false.
0
 

Author Comment

by:BBrayton
ID: 39194197
If I stop the sharepoint server service and the sharepoint timer server the server does backup. It backed up yesterday then I turned the services back on and the scheduled backup failed last night.
0
 
LVL 8

Accepted Solution

by:
PaulD77 earned 1500 total points
ID: 39194213
Ok, well I'm hoping your database is still there.  Take a look at this article, skip over the restore part and start from reconnect to central admin

http://technet.microsoft.com/en-us/library/cc561036(v=office.12).aspx

If the DB is not there, you may need to restore from a backup

This may help you as well:

http://technet.microsoft.com/en-us/library/cc561011(v=office.12).aspx
0
 

Author Comment

by:BBrayton
ID: 39194216
I get this error on step 5 of 6 Failed to upgrade Sharepoint products


An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfig
urationTaskException was thrown.  Additional exception information: The upgrade
command is invalid or a failure has been encountered.
Failed to upgrade SharePoint Products.

Total number of configuration settings run: 5
Total number of successful configuration settings: 4
Total number of unsuccessful configuration settings: 1
Successfully stopped the configuration of SharePoint Products.
Configuration of SharePoint Products failed.  Configuration must be performed be
fore you use SharePoint Products.  For further details, see the diagnostic log l
ocated at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\1
4\LOGS\PSCDiagnostics_5_24_2013_9_15_11_740_725939300.log and the application ev
ent log.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question