Mirroring & Filestream in SQL 2008

Question

Mirroring & Filestream in SQL 2008

Jayakumar Krishnan

SSCarpal Tunnel

Points: 4710
More actions
July 19, 2010 at 8:55 pm

#224261

Comments posted to this topic are about the item Mirroring & Filestream in SQL 2008
Thanks
Jay
http://www.sqldbops.com

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

gary.rumble SSCommitted Points: 1904 More actions · Answer 1

None? Can this column accept nulls?

I guessed and got it right. Pretty much assumed that you wouldn't have asked if the answer was yes. The results are running pretty close to 50/50, so I guess I'm not alone.

Learned something, though.

14090 SW TENNESSEE LN

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Thanks for the question. It was useful to learn a little something about filestreaming.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Dan Guzman - Not the MVP Hall of Fame Points: 3757 More actions · Answer 3

I would say my guess was more 75-25 to No, because file streaming is new, and the way the files are managed in SQL server is unique, so full integration with mirroring would seem square peg/round hole -ish (technical term)

Thanks for the question.

UMG Developer SSChampion Points: 13482 More actions · Answer 4

Nice question, thanks!

I am a little curious what the "none" options was meant to be. (Or did you just want two choices, and forgot to delete the default third choice that is created for you on the QotD editor?)

Rick.Cornell.SME SSCrazy Eights Points: 8597 More actions · Answer 5

Thanks for the question, had to look up the answer on this one!

Jayakumar Krishnan SSCarpal Tunnel Points: 4710 More actions · Answer 6

Thanks for the comments... Thought of give a different 3rd choice of answer for this question to confuse the readers but didnt realize that will mislead here... :blink:

Thanks
Jay
http://www.sqldbops.com

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 7

I've updated the question to mark the last answer, none, as wrong.

Vladimir Sotirov SSC Eights! Points: 921 More actions · Answer 8

Do you think that Microsoft will work on supporting Filestream with mirroring in near future? I wood like to be able to use both technologies.

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 9

I am sure it will evolve, but I have no information as to when it will get included in the product.

TomThomson SSC Guru Points: 104773 More actions · Answer 10

interesting question.

I spent some time looking at filestream a month or two back (trying to work out whether to suggest to someone that they use it) and came across the answer to this one then.

I don't understand the 2% who went for the third answer (whether it was "None" or "Wrong Question" when the answered it).

Tom

TomThomson SSC Guru Points: 104773 More actions · Answer 11

Vladimir Sotirov (7/20/2010)
Do you think that Microsoft will work on supporting Filestream with mirroring in near future? I wood like to be able to use both technologies.

I hope they'll give encryption for filestream priority - both cell level and TDE options.

Tom