0

When creating a remote BLOB store in SQL Server (2008 R2) is "RBSFilestreamFile" always the name of the file when adding it to the FILEGROUP like in this query (this is the name I've seen used in every example I've found online, but I need to know for sure)?

ADD FILE (name = RBSFilestreamFile, filename = 'c:\Blobstore')
    TO FILEGROUP RBSFilestreamProvider

I'm asking because I'm working on an application for restoring SharePoint content databases and need to know if I can hardcode this string into the application.

I know you can create file groups and files with any name you want, but specifically for setting up RBS with SharePoint using SQL 2008's built in FILESTREAM provider are these names an expected convention? i.e. Will it work if I name my FILEGROUP and/or FILE something else?

migrated from serverfault.com May 29 '13 at 22:07

This question came from our site for system and network administrators.

1

The filename and filegroup name are not fixed.

SharePoint will use the same name when creating the databases. However there's nothing that would prevent someone from changing those names to something else if they desired. I'd query for them from the database backup using RESTORE FILELISTONLY then create the RESTORE DATABASE Command based off that information.

  • Please see updated question, this doesn't entirely help. – mclaassen May 30 '13 at 15:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.