March 6, 2012 at 1:02 pm
Hi,
We have enable FileStream feature for instance INS1 and configured RBS for Share Point Content databases using filestream
We have another database called Mydb which is NOT configured for Filestream.
Question:
1.
Can we use Database Mirroring for Mydb?
2.
if enabled Filestream feature for an instance, then we can not use database Mirroring for any database on that particular instance. Is that correct? Please advise..
Thanks
March 6, 2012 at 1:10 pm
you may mirror mydb as long as it has no filestream filegroups, this is detailed in Books Online
http://technet.microsoft.com/en-us/library/bb895334.aspx#DatabaseMirroring
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 6, 2012 at 1:10 pm
gmamata7 (3/6/2012)
Hi,We have enable FileStream feature for instance INS1 and configured RBS for Share Point Content databases using filestream
We have another database called Mydb which is NOT configured for Filestream.
Question:
1.
Can we use Database Mirroring for Mydb?
2.
if enabled Filestream feature for an instance, then we can not use database Mirroring for any database on that particular instance. Is that correct? Please advise..
Thanks
Regarding #1, Yes. Regarding #2, No.
When SQL Server 2012 becomes available, if you move to it and use Always On, then the answer to both becomes yes.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply