Solved

Sharepoint spconfig fails and now SBS2011 will mot back up.

Posted on 2013-05-24
7
611 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
  • 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

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 500 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

832 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