.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Full Farm Backup Fails on Windows Sharepoint Services Search Database

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :SharePoint
I am just now starting to us central administration to backup the entire sharepoint farm.  All content backups fine except for the Search Database.  In looking through the backup log, it appears that the search database may not exist.  How can I determine if the search database actually does exist and if it does not can it be recreated?

View Complete Post

More Related Resource Links

Windows SharePoint Services 3 Search Event ID 2424


This error started on 29 April and I cannot get rid of it...  My search works fine, both site and people.  AD profile import works fine.  Full and incremantal crawls work as scheduled.  Just that this error keeps showing up every five minutes in one of two WFE's.  The other WFE does not receive this error


I have verified all Security Configuration/Service Accounts, verified all Services on Server/Search accounts, Stopped/Restarted all search, and verified SSP accounts.  The last thing I did was verify there was an indexer attached to the SSP...

I set the diagnostic logging to verbose and the only thing that stood out around the time of the error was

System.Data.SqlClient.SqlException: Invalid object name 'AR_CacheCounters'.

SqlError: 'Invalid object name 'AR_CacheCounters'.'    Source: '.Net SqlClient Data Provider' Number: 208 State: 1 Class: 16 Procedure: 'proc_ar_GetCacheInvalidationCountersWithCount' LineNumber: 3 Server: 'SERVER'


Any suggestions?







Windows SharePoint Services v3.0 Database Error

Hi Below is the error from event viewer on the server based on the Above Event Type:     Error Event Source:  Windows SharePoint Services 3 Event Category:          Database Event ID:         3758 Date:               3/18/2009 Time:               4:38:40 PM User:                N/A Computer:       FIB-PORTAL Description: Database full error on SQL Server instance 'FIB-PORTAL\OfficeServers' in database 'WSS_Content'. Additional error information from SQL Server is included below.   Could not allocate space for object 'dbo.EventCache'.'EventCache_Id' in database 'WSS_Content' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.   For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.   Event Type:     Error Event Source:  MSSQL$OFFICESERVERS Event Category:          (2) Event ID:         1827 Date:               3/18/2009 Time:               4:38:40 PM User:                FIRSTINLAND\sharepointadmin Computer:       FIB-PORTAL Description: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.Any ideas on the Solution to the Above Issue...Best Regards,Adeoye...

SharePoint Farm Backup Error in Search instance function

I'm working with MS Project Server 2007 with SharePoint WSS. When doing a full farm backup in SharePoint Central Admin > Operations > Backup and Restore > Perform a Backup, I encountered 2 errors in "SharePoint Windows Services Search, Search instance". 1) Error: Object a8b2cbfe-ef8b-45ce-92a0-c5675f534ec0 failed in event OnBackup. For more information, see the error log located in the backup directory.  InvalidOperationException: System.NullReferenceException: Object reference not set to an instance of an object.    at Microsoft.SharePoint.Search.Administration.SPSearchBackupRestoreTimerJob.Execute(Guid targetInstanceId)   2) Error: Object a8b2cbfe-ef8b-45ce-92a0-c5675f534ec0 failed in event OnBackupComplete. For more information, see the error log located in the backup directory.  Object a8b2cbfe-ef8b-45ce-92a0-c5675f534ec0 failed in event OnBackup. For more information, see the error log located in the backup directory.  InvalidOperationException: System.NullReferenceException: Object reference not set to an instance of an object.    at Microsoft.SharePoint.Search.Administration.SPSearchBackupRestoreTimerJob.Execute(Guid targetInstanceId)  InvalidOperationException: System.NullReferenceException: Object reference not set to an instance of an object.    at Microsoft.SharePoint.Search.Administ

Windows Sharepoint Services Search

I am running WSS 3.0 SP1.  It appears that my database the goes along with Windows Sharepoint Services Search no longer exists.  I have no way of restoring the database.  This is causing my complete farm backup to fail with errors.  Can Windows Sharepoint Services Search be removed completely from my Farm without affecting Sharepoint and my current applications?  I want to be able to perfrom a clean (no errors) full farm backup daily. Thanks for your help!

Can i use Windows desktop search indexing service to index a full sql database ?



i wonder if i can use the windows indexing service to perform indexing on a database instead of file system ?

i.e we need to use the windows indexing service to create index table that contains information from all rows in the database



Why does Windows Sharepoint Services Search want access to non-sharepoint databases.


I have installed a new instance of Sharepoint 2007 and am in the process of configuring all the farm services.  At the moment the farm consists of a sharepoint box and a separate sql server.  Here is the catch.  There are already some non-sharepoint databases on the sharepoint server.  The account under which Central Administration runs has dbcreator and securityadmin privileges in the database.  The Sharepoint_Config and SharePoint_AdminContent databases were created without any issues.

When I try to start the Windows Services Search, I get an "Unknown Error."  Looking in the event viewer gives the following error "The server principal "MyServerPrincipal" is not able to access the database "MyDatabase" under the current security context."  This is true, MyServerPrincipal does not have privileges to access MyDatabase, but why should it.  MyDatabase has nothing to do with sharepoint.  

In an attempt to get past this issue, I gave MyServerPrincipal public access to MyDatabase, but that resulted in an additional error saying that it lacked INSERT privileges.  This is really worriesome.  Does anyone know why Sharepoint Search configuration would try to access the non-Sharepoint database?


Thanks a lot.

Windows SharePoint Services 3.0 Application Template: Bug Database - can you customize the emails?

My company is using a ms appliation template downloaded here: http://www.microsoft.com/downloads/details.aspx?FamilyId=C72D23AF-F556-47AA-A6F2-0027246A9928&displaylang=en#RelatedLinks.  How can I change the emails that get sent when an application is assigned?

Windows Sharepoint Services 3 search not working getting event ids 2424 and 2436.


I can login with the accounts for content and the search service on the local server.

I have the loopback reg fix.

But the crawler will not crawl.

I have deleted all search databases in sql and it I have created one from scratch and setup different accounts for the content and search service.

I downloaded and installed windows sharepoint services 3 with service pack 2 on another server and when I used the same accounts that I had on the non working sharepoint install the search worked.



How to make Windows SharePoint Services use a preexisting database as the content database

From the link below. I am trying to find in Central Administration the following:

  • Replace each instance of AdminVsAppPoolIdentity in the query with the account that is the SharePoint Central Administration virtual server application pool identity. This account is also the database owner (dbo) of the database.
  • Replace each instance of ContentVsAppPoolIdentity in the query with the account that is the content virtual server application pool identity.

  • http://support.microsoft.com/default.aspx/kb/888041

    Where do I find the AdminVsAppPoolIdentity and ContentVsAppPoolIdentity ??

    Windows Live Small Business and SharePoint Services Back-End Database


    According to the Windows Live Small Business (WLSB) help content, there is a means to setup a survey that will allow you to use Sharepoint list data from the back-end of a WLSB web site to validate an entry from a front-end web site answer. If this is still possible, is there any current detail information that demonstrates a step by step approach to how it can be done. The usefullness of this solution would aid in web page development allowing for the developer to have a landing page in which a client or customer could fill out a survey, enter their client identification number, and then have the Sharepoint list data on the back-end validate the user's id so that if the id is not a valid pre-pitted id entry or storage of the survey entry could be declined.

    Do any of you have knowledge that you could share in order to solve this solution delima?

    MCITP-SA, MPN, CRCP, and WestconGroup Partner; http://oguninternationalmedia.com

    Windows Sharepoint Services 3 search not working getting event ids 2424 and 2436


    This the default install running on Windows 2008 64 bit.

    Our content database is located on the d drive and the Sharepoint services 3 install located on the c drive.

    We constantly get event ids 2424 and 2436 when the index tries to run. Which is every five minutes.

    I have the loopback fix in place.

    This was working fine and then it stopped working. When doing a search on sharepoint we were able to pull up some data but not the newest data.

    I  deleted the search database and created a new one with a new name.

    I also downloaded and installed a new install of sharepoing services 3 and used the same domain accounts for the search service and the content and the index worked when I uploaded something. I was able to do a search.

    I tried running a repair on the sharepoint services 3 install and it didn't work.

    I hope it is not necessary to re-install everything from scratch.


    Not exactly sure why I don't get id 2424 anymore but it is not there.


    event ids are listed below

    Log Name:      Application
    Source:        Windows SharePoint Services 3 Search
    Date:          11/16/2010 11:45:02 AM
    Event ID:      2436
    Task Category: Gathe

    SharePoint 2010 backup is failing - Error - "Unable to read full interval from database - Operation



    I am having a problem backing up a site collection, when trying to backup the collection I get the following error "Unable to read full interval from database" and "operation is not valid due to the current state of the object".

    The backup does run and manages to backup 182MB of the site collection and then the backup fails, it fails at the same point what ever backup method I use e.g. STSADM, Powershell or Central Admin.

    I'm getting the same error whether I use CA "granular backup" or "Farm backup", and using either STSAMD or Powershell. I can backup CA or the mysite collection but not the Home Portal site collection. I even tried installing the commuvaults 2010 agents and running a commuvault backup but this is also failing. i have included the log file entry below.

    Does anyone have any suggestions on what i can do to either fix the problem or an alternative way to backup the collection or farm, I am currently taking a full SQL backup but am not sure how reliable this is as I haven't tried to restore the sites. 

    P.S. I am not using the "UseSQLSnapshot" parameter.

    11/30/2010 09:34:25.23  OWSTIMER.EXE (0x17E8)                 

    Getting Started with Windows SharePoint Services

    Of all of the capabilities of SharePoint, I thought I would start with the most basic installation - as a corporate intranet. It is likely that we will need to discuss some of the elements of SharePoint as we go along, so this also gives us the opportunity to review these elements for future reference.

    Before going into too much detail, I would like to point out that you can try the core SharePoint framework (known as Windows SharePoint Services or WSS) for free. On Microsoft's Web site you can download a trial version of Virtual PC 2004 (VPC). Using VPC, you can install the Windows 2003 Evaluation Kit and the WSS add-on. This combination will give you 45 days to evaluate the setup.

    Building a Searchable Phone Directory with Windows SharePoint Services

    I want to continue to build out the intranet site we've started in our previous articles. A standard item in every intranet is a staff/employee list. Most companies implementing Windows SharePoint Services (WSS) are large enough to have a database that contains all employees. We will use the aggregation features of SharePoint to include data from this database into our intranet.

    New Features in Windows SharePoint Services 3.0

    Windows SharePoint Services 3.0 (WSS 3.0) is the next version of WSS 2.0, released on 2007, and Microsoft Office SharePoint Server 2007 (MOSS 2007) is built on top of this. Windows SharePoint Services 3.0 takes full advantage of Microsoft ASP.NET 2.0 and the core Microsoft .NET 2.0 runtime. WSS 3.0 offers a lot of new features and programmability support. I have consolidated a list of new features and enhancements in the below section:

    Take Control: Use SharePoint to Manage Your Windows Services


    In this article, we show you how to integrate a Windows Services-based solution with SharePoint. The results enable you to provision, start, stop, and remove service instances through SharePoint 3.0 Central Administration.

    Pav Cherny

    MSDN Magazine April 2009

    SharePoint: Add a Recycle Bin to Windows SharePoint Services for Easy Document Recovery


    Windows SharePoint Services helps improve collaboration and workflow while protecting documents and intellectual property. But one feature is conspicuously missing - an easy way to back up and restore deleted files from document libraries. In this article, the authors take advantage of the extensibility of WSS and its server-side and client-side object models to build a restore feature that works like the Recycle Bin in Windows Explorer.

    Maxim V. Karpov and Eric Schoonover

    MSDN Magazine February 2005

    ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
    Sql Server  SharePoint  Silverlight  Others  All   

    Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend