Solved

Remote Blob Storage with SQL 2012 - Only for Sharepoint?

Posted on 2013-11-20
3
482 Views
Last Modified: 2013-11-28
Hi,

we are looking for a way to store users file on remote storage and have it all indexed in SQL using filestream.
The first option that we've tried is to use filestream with file table, however, the problem is that file table can only export UNC and not use existing UNC that is shared from other servers.
So I've come to read about RBS.
The question is if RBS can solve this issue, so I can store the users file on remote UNC and have it indexed in SQL, or is this feature is limited only to Sharepoint?

Thank you in advance
0
Comment
Question by:webox_suuport
[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
3 Comments
 
LVL 6

Accepted Solution

by:
emadallan earned 500 total points
ID: 39662183
RBS is limited to SharePoint and all its config is done through SharePoint Management Shell, however you can make a full text indexing:
see this url:
http://technet.microsoft.com/en-us/library/bb895334.aspx#FullText
0
 

Author Comment

by:webox_suuport
ID: 39662301
Alright,
so since RBS is limited to SharePoint and filestream is limited to physical storage, both are useless for my needs.

Do you know if and how I can achieve it?
The topology is simple:
1 Windows File Server with published share  - \\share\folder
1 SQL server.

So it should be the: users storing files in \\share\folder.
Everything will be written in DB but the files will be stored not on SQL.
0
 
LVL 34

Expert Comment

by:ste5an
ID: 39665273
Please define precisely what you want to store, how you want to access it from the client side and what exactly SQL Server should index..
0

Featured Post

Turn Insights Into Action

You’ve already invested in ITSM tools, chat applications, automation utilities, and more. Fortify these solutions with intelligent communications so you can drive business processes forward.

With xMatters, you'll never miss a beat.

Question has a verified solution.

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

As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

695 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