AW: [Samba] Running SQL over SAMBA?

[Pseudomizer]

Hello Jeremy,

with all respect but this will not work. Microsoft specifically excluded the
ability to store SQL on any network share. You can only place SQL and
Exchange (not PST files) on local drives (block based). The only way to get
SQL or Exchange running over Ethernet is via iSCSI (block based) and not on
NAS.

You could modify the registry to place SQL and Exchange on a network share
but this will eliminate any support from Microsoft if there would be any
issue.

Best regards,

Pseudomizer

-----Ursprüngliche Nachricht-----
Von: samba-bounces+pseudomizer=lovetalks.de at lists.samba.org
[mailto:samba-bounces+pseudomizer=lovetalks.de at lists.samba.org] Im Auftrag
von Jeremy Allison
Gesendet: Montag, 27. März 2006 12:07
An: Ephi Dror
Cc: samba at lists.samba.org
Betreff: Re: [Samba] Running SQL over SAMBA?

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.
-- 
To unsubscribe from this list go to the following URL and read the
instructions:  https://lists.samba.org/mailman/listinfo/samba