samba - Mar 2004 - Trying to put a MS SQL 7.0 database on a samba share

Hi,

I have a linux box set up with Samba 3.0 and have configured my shared 
drives. What I am trying to do is store a MS SQL data base on my Samba 
share.
I can see the drive from my SQL machine but when I try create the database 
there I get errors like inconsistent file names etc.

Fist can this be done and if so how?


Thanx
Warren

This seems like a VERY bad thing to do anyways.

Usually putting transactional databases of any kind... like bdb
database, or any of hte like, on a shared drive is a recipe for
disaster. I'd guess SQL falls into this same category, but don't know
it. Anyways this would be super slow? why put a db on a share?


On Wed, 2004-03-03 at 04:44, Warren Green wrote:
> Hi,
> 
> I have a linux box set up with Samba 3.0 and have configured my shared 
> drives. What I am trying to do is store a MS SQL data base on my Samba 
> share.
> I can see the drive from my SQL machine but when I try create the database 
> there I get errors like inconsistent file names etc.
> 
> Fist can this be done and if so how?
> 
> 
> Thanx
> Warren 
-- 
Jerry Haltom <jhaltom@feedbackplusinc.com>
Feedback Plus, Inc.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url :
http://lists.samba.org/archive/samba/attachments/20040303/fe2179fe/attachment.bin

I would like to centralize all the company data to one central box. The 
box does have dual gigabit network cards, so will the MS SQL server have a 
gig network card to my Samba server. All the clients are running 100mb.

Anyone else with any comments would be greatly appreciated.


Thanx
Warren

> This seems like a VERY bad thing to do anyways.
> 
> Usually putting transactional databases of any kind... like bdb
> database, or any of hte like, on a shared drive is a recipe for
> disaster. I'd guess SQL falls into this same category, but don't
know
> it. Anyways this would be super slow? why put a db on a share?
>

>Hi,
>I have a linux box set up with Samba 3.0 and have configured my shared 
>drives. What I am trying to do is store a MS SQL data base on my Samba 
>share.
>I can see the drive from my SQL machine but when I try create the database 
>there I get errors like inconsistent file names etc.
>Fist can this be done and if so how?
>Thanx
>Warren 
The short answer is no.. Ms SQL requires that its databases are stored on a
local disk, This is by design of the application it doesnt matter if its Windows
, Samba etc making the shares available.

The only way to create a "non-local" database is through use of
specifically crafted drivers which are written in order to make the remote share
appear local. This is how appliances such as NetApp work.

If you are worried about it for backup purposes simply dump your SQL to disk
nightly onto the shared drive.