Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Sharepoint spconfig fails and now SBS2011 will mot back up.

Posted on 2013-05-24
7
Medium Priority
?
642 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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 

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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
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
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

636 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