[Samba] Running SQL over SAMBA?

[Jeremy Allison]

On Mon, Mar 27, 2006 at 09:50:31AM -0800, Ephi Dror wrote:
> Hi All,
>  
> Does anyone run SQL and/or exchange on SAMBA server share?
>  
> Are there any special considerations to take? would you be kind enough
> to share your experience doing it?
>  
> Any special smb.conf configuration is required?
> is there any performance issue  or functional limitations supporting it?
>  
> I am just wondering since Microsoft encourages block level access over
> share/file level access. 
>  
> http://support.microsoft.com/default.aspx?scid=kb;en-us;304261  
> Microsoft generally recommends that you use a Storage Area Network (SAN)
> or locally attached disk for the storage of your Microsoft SQL Server
> database files because this configuration optimizes SQL Server
> performance and reliability. By default, use of network database files
> (stored on a networked server or Network Attached Storage [NAS]) is not
> enabled for SQL Server.
> 
> However, you can configure SQL Server to store a database on a networked
> server or NAS storage server. Servers used for this purpose must meet
> SQL Server requirements for data write ordering and write-through
> guarantees detailed in the "More Information" section of this article.
> . 
> http://support.microsoft.com/kb/234656/ 
> All versions of SQL Server open the log and data files using the Win32
> CreateFile function. The dwFlagsAndAttributes member includes the
> FILE_FLAG_WRITE_THROUGH option when opened by SQL Server. 
>  
> All comments are welcome and highly appreciated.

Should work. If you have problems let us know and we'll fix 'em.

Jeremy.