Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

RBS (Remote BLOB Storage) Expand / Collapse
Author
Message
Posted Monday, September 2, 2013 3:51 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 4:38 AM
Points: 16, Visits: 68
Hi all,

I'm looking into creating a new database for a fairly large application, which includes a feature for creating and storing many thousands of Word and PDF documents. The application that's being replaced stores the documents in a share on a NAS physically separated from the database server, for performance reasons, but the documents aren't in the database - the database records just include filepath pointers to the documents. Indexing of the documents' contents is done using a 3rd party tool.

I'd like to have the documents stored in the database as BLOBs, ideally, to allow for more advanced indexing and querying, but from what I'm reading it's only possible to store the documents on a different server than the database if we have the Enterprise edition of MSSQL. Is that correct? If so, that seems a bit ridiculous - who would want to store the files on the same server as the database?

I've enquired and found that Enterprise edition would be prohibitively expensive for us. If I'm correct that Enterprise edition is the only way to store files off-server, is there a workaround? Has anybody had experience doing this sort of thing before?
Post #1490566
Posted Monday, September 2, 2013 4:05 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, January 31, 2014 2:56 AM
Points: 483, Visits: 256
Have a closer look at the FILESTREAM support and/or FileTable features. They are supported by every edition of SQL Server.
Post #1490574
Posted Monday, September 2, 2013 4:07 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 4:38 AM
Points: 16, Visits: 68
Thanks for the reply. I know those features are supported in every edition, but the implication on this page is that FILESTREAM and File Table only support files on the same server as the database except with Enterprise edition.
Post #1490575
Posted Monday, September 2, 2013 7:29 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, January 31, 2014 2:56 AM
Points: 483, Visits: 256
The link you provided goes to the 2008 R2 version. Here's the 2012 version: http://msdn.microsoft.com/en-us/library/gg638709.aspx/css. However, it doesn't add much infomation as far as I can see.

I don't know your storage solution, but we connect our database servers to the SAN via iSCSI which SQL Server sees as local disks.
Post #1490617
Posted Monday, September 2, 2013 8:11 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 4:38 AM
Points: 16, Visits: 68
Thanks for that. I did think about using an iSCSI connection, that might well be a way around the problem.
Post #1490631
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse