THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Allen White

Oh, What a Tangled Web

At Tech Ed 2008 I made a mental note when Paul Randal mentioned that you can't use Database Mirroring when you've got the Filestream feature turned on. I like Database Mirroring and so that was useful information.

In preparing a bunch of demos for SQL Server 2008, I'm using the AdventureWorks2008 database currently available on the Codeplex site. Installing this database requires the Filestream feature, so I turned it on.

Some of the demos I'm working on are existing demos written for the AdventureWorks database on SQL Server 2005, and I've found many of them don't work. It turns out that the structure of the database has been modified, eliminating some tables commonly used in demos (Person.Contact, for example), and changing the column names of primary keys as well as other columns.

I also discovered that you can't set the READ_COMMITTED_SNAPSHOT and the ALLOW_SNAPSHOT_ISOLATION options on if the Filestream feature is enabled, so to demo those options I'll have to load the old AdventureWorks database as well as the new AdventureWorks2008 database.



Published Thursday, July 31, 2008 10:17 AM by AllenMWhite
Filed under:



a.m. said:

Ugh.  I didn't realize there was a limitation around snapshot isolation when using filestream.  I think that's going to greatly reduce its potential for use.  I guess the workaround will be to create a separate database just for the filestream stuff...

July 31, 2008 11:21 AM

James Luetkehoelter said:

I agree - methinks that will be something that will be corrected with a later service pack - its too likely that someone would combine FILESTREAM, database mirroring or snapshot isolation.

I see the logic in why using FILESTREAM would make life difficult for these other features, but definitely not technically impossible.

July 31, 2008 8:00 PM

Paul Nielsen said:

At least FileStream can be enabled and disabled.

October 3, 2008 7:07 PM
New Comments to this post are disabled

About AllenMWhite

Allen White is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. He has worked as a Database Administrator, Architect and Developer for over 30 years, supporting both the Sybase and Microsoft SQL Server platforms over that period.

This Blog


Privacy Statement