SharePoint supports SQL RBS using SAN or Local disks

There’s a lot of information around Technet on what is and is not supported when looking at RBS for SQL (and SharePoint). Some of it could even be construed as contradictory… so I asked through the Partner forum what Microsoft’s official position on this was:

Does the RBS Provider on SQL 2008 support Remote Storage?

The answer at this stage is No… BUT luckily SAN storage appears as a Local disk (the integration happens at a hardware level, so it’s not the same as a mapped network share for example). This means that you can attach a SAN disk to your SQL Server (as most enterprises do) and use it to host your BLOBs.

Want more proof? My initial Managed Newsgroup question and Microsoft’s answer, straight from the horses mouth… SharePoint and SQL RBS + FILESTREAM Storage Provider on Remote Disks.

Also, “local file system” means local NTFS – SMB is not allowed, so mapped network drives will not work. If SAN is connected via HBA card and is recongized as a local drive directly (not via net share mapping) it could be used by RBS filstream as I know.

This means that SQL backups give you a point-in-time backup, just the way it works now. No muss, no fuss… no 3rd party products to contend with 🙂

B

Advertisements

About Brad Saide

I'm a SharePoint consultant. I'm also slowly going bald, seem to have a permanent spare tyre around my waist and enjoy socialising with friends over a beer or 10. The last 2 may possibly be related. Started working with SharePoint when the first version was in limited beta release (participated in the Technology Adoption Program while at Woolworths) and have been committed to the adoption of the technology as a business enabler ever since.
This entry was posted in Uncategorized. Bookmark the permalink.

2 Responses to SharePoint supports SQL RBS using SAN or Local disks

  1. HP says:

    Hi, you have mentioned .
    “SAN is connected via HBA card and is recongized as a local drive directly (not via net share mapping) it could be used by RBS filstream as I know”
    Can you please point to any article which made this setting work?
    Any caveats to it ?

    Thanks in advance
    HP

    • Brad Saide says:

      Hi HP

      The link in the article links to a Statement made by a Microsoft employee who got it from the product team. However I have not ever set it up – Check back with me in a few months though because I will be next month. In the meantime, you’ll have to google for it.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s