February 19, 2010 at 10:55 pm
In all information i searched, I see two conflicting statements:
1) If you are on a FAILOVER CLULSTERING environment place the FILESTREAM file groups in a shared disk.
2) FILESTREAM data can be stored only on local disk volumes.
Can someone explain which of these is correct. I intend to use filestream in a clustered environment. In case of a failover, I want the data stored to be accessible from the partner database. Therefore I believe I must store the data on a shared disk. But as per above statements if it can be stored only on a local disk, how can the data be made available in a failover clustering environment?
February 20, 2010 at 1:29 am
February 20, 2010 at 6:55 am
That is a link to a Microsoft White Paper by Paul Randal.
This is a clickable link to it: FILESTREAM Storage In SQL Server 2008
@gt: you can use the [ url ] and [ /url ] tags to make your links more user-friendly
(remove the spaces from the tags)
Paul
February 21, 2010 at 10:17 pm
Thanks, Dude! I Didn't know, i am still new to this forum.:-)
EnjoY!
February 21, 2010 at 10:22 pm
GT-897544 (2/21/2010)
Thanks, Dude! I Didn't know, i am still new to this forum.:-)
No worries - it's a question that most poeple ask at some stage.
One day, SSC will have a nice editor*...;-)
* I mean the post-construction tool, not Steve
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy