Solved

Implementing Sharepoint 2010 RBS & Search

Posted on 2013-02-06
3
584 Views
Last Modified: 2013-02-26
Hello

I am trying to resolve the 4gb limitation of MSQL Express. I upgraded to MSDE Express R@, supposed ot now be 10GB limited. MY Sharepoint Search is stopped as result of 4gb limit. I have recreated the application and verified correct DB size but still same error.

Yeserday I found this could be avoided using RBS. Installed the various componet of RBS. Tried the command line for RBS but cannot see my SQL server instance name, tried all variations of the name. If I run the RBS_amd64 GUI install it works for my WSS_Content but my search db's are other names and when i try install enable RBS on them it fails.

http://daxdilip.blogspot.com.au/2012/10/configuring-and-implementing-sharepoint.html
http://www.sp-blogs.com/blogs/adnan/Lists/Posts/Post.aspx?ID=9

Some of the errors
The installer has encountered an unexpected error. The error code is 2769.
Remote Blob Storage on the database has failed with error message:
A network-related or instance-specific error

for DBInstance have tried "sharepoint", "servername\sharepoint" with quotes, without them etc.

any help appreciated.

john
0
Comment
Question by:escadmin
  • 3
3 Comments
 

Author Comment

by:escadmin
ID: 38859801
Update

Figured out the command line to get WSS_Content setup with RBS.
Had to enable named pipes and used servername\sharepoint.

Now I run the same command on for my other "search" databases, do not see any errors but the RBS tables never get created in databases.

john
0
 

Author Comment

by:escadmin
ID: 38859923
Tried to enable the databse anyway.
$cdb = Get-SPContentDatabase <ContentDatabaseName>
$rbss = $cdb.RemoteBlobStorageSettings
$rbss.Installed()
$rbss.Enable()
$rbss.SetActiveProviderName($rbss.GetProviderNames()[0])
$rbss

This failed as my search db is not a content database. For tesing i just created a new Content databse in sharepoint. Added the blob folder filegroup etc.  
Followed this link again
http://www.knowledgecue.com/pdf/ConfiguringRemoteBlobStorageforSharePointKnowledgeCue.pdf

Ran the comnad above again.
$cdb = Get-SPContentDatabase <ContentDatabaseName>
$rbss = $cdb.RemoteBlobStorageSettings
$rbss.Installed()
$rbss.Enable()
$rbss.SetActiveProviderName($rbss.GetProviderNames()[0])
$rbss

See the wss_content_test database but message "SQL remote blob storage must be installed on each contect database" i have run the command several times. compare output to original WSS_Content log files and you can see the tables are not being created on the 2nd databse.

john
0
 

Accepted Solution

by:
escadmin earned 0 total points
ID: 38929903
No response, closing ticket.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Insert to Begin if data exists 2 31
SQL Activity Monitor detail 2 23
TSQL Challenge... 7 35
SCCM 2012 R2, Rollback KB updates 4 14
In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

789 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