Can't create database on non-local drive

28/09/2006, 13h26

KB article 304261 says you can use a non-local (network) drive (NAS, SAN)
with SQL server 2000. I've got Trace flag 1807 set on (as per article) but
it fails with error 5105 (not 5110 as per article). Has anyone done this
successfully?

Running SQL Server 2000 SP3 standard edition on Windows 2000 server SP4.

28/09/2006, 14h10

If you are planning on placing a database file on a mapped network drive,
don't go there. It's not worth whatever you are trying to save.

Linchi

"Curtis White" <Curtis White@discussions.microsoft.com> wrote in message
news:74C5C93A-98CE-4914-A289-A3D6F6515D77@microsoft.com...
> KB article 304261 says you can use a non-local (network) drive (NAS, SAN)
> with SQL server 2000. I've got Trace flag 1807 set on (as per article)
> but
> it fails with error 5105 (not 5110 as per article). Has anyone done this
> successfully?
>
> Running SQL Server 2000 SP3 standard edition on Windows 2000 server SP4.

29/09/2006, 10h08

I've never gotten network drives to work properly with SQL2000. Better
to use UNC names.

However, I'm with Linchi Shea on the point that it's not a good idea,
even if you *can * do it....

Regards,
Hank Arnold

Curtis White wrote:
> KB article 304261 says you can use a non-local (network) drive (NAS, SAN)
> with SQL server 2000. I've got Trace flag 1807 set on (as per article) but
> it fails with error 5105 (not 5110 as per article). Has anyone done this
> successfully?
>
> Running SQL Server 2000 SP3 standard edition on Windows 2000 server SP4.

28/09/2006, 13h26	#1 (permalink)
Curtis White Messages: n/a Hébergeur:	Can't create database on non-local drive KB article 304261 says you can use a non-local (network) drive (NAS, SAN) with SQL server 2000. I've got Trace flag 1807 set on (as per article) but it fails with error 5105 (not 5110 as per article). Has anyone done this successfully? Running SQL Server 2000 SP3 standard edition on Windows 2000 server SP4.

28/09/2006, 14h10	#2 (permalink)
Linchi Shea Messages: n/a Hébergeur:	Re: Can't create database on non-local drive If you are planning on placing a database file on a mapped network drive, don't go there. It's not worth whatever you are trying to save. Linchi "Curtis White" <Curtis White@discussions.microsoft.com> wrote in message news:74C5C93A-98CE-4914-A289-A3D6F6515D77@microsoft.com... > KB article 304261 says you can use a non-local (network) drive (NAS, SAN) > with SQL server 2000. I've got Trace flag 1807 set on (as per article) > but > it fails with error 5105 (not 5110 as per article). Has anyone done this > successfully? > > Running SQL Server 2000 SP3 standard edition on Windows 2000 server SP4.

29/09/2006, 10h08	#3 (permalink)
Hank Arnold Messages: n/a Hébergeur:	Re: Can't create database on non-local drive I've never gotten network drives to work properly with SQL2000. Better to use UNC names. However, I'm with Linchi Shea on the point that it's not a good idea, even if you can do it.... Regards, Hank Arnold Curtis White wrote: > KB article 304261 says you can use a non-local (network) drive (NAS, SAN) > with SQL server 2000. I've got Trace flag 1807 set on (as per article) but > it fails with error 5105 (not 5110 as per article). Has anyone done this > successfully? > > Running SQL Server 2000 SP3 standard edition on Windows 2000 server SP4.

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email