Re: [Samba] Running SQL over SAMBA?
On Mon, Mar 27, 2006 at 09:50:31AM -0800, Ephi Dror wrote:[color=blue]
> 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.
> 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.
> 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.[/color]
Should work. If you have problems let us know and we'll fix 'em.
To unsubscribe from this list go to the following URL and read the