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

Sharepoint spconfig fails and now SBS2011 will mot back up.

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
BBrayton
Asked:
BBrayton
  • 4
  • 3
1 Solution
 
PaulD77Commented:
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
 
BBraytonAuthor Commented:
I tried that it does not some up with anything.  it just starts a new command line.
0
 
PaulD77Commented:
I would run the PSconfig anyway just to force any updates.  The site will go down for a few minutes while it runs
0
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.

 
BBraytonAuthor Commented:
If I don't put in the computer name and leave the line as default it tells me false.
0
 
BBraytonAuthor Commented:
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
 
PaulD77Commented:
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
 
BBraytonAuthor Commented:
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

Independent Software Vendors: 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!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now