Data Directory In Network location?

Is it possible to set DATADIR=\\<company_network_somedirectory>\? When I
try it, set-up seems to fail.
Also, if I were to create a new database on a default instance of MSDE, I am
not able to pick mapped network directories.
Appreciate any insight.
Thanks,
Sha.
hi Sha,
"Sha S." <shajihans@.ttnus.com> ha scritto nel messaggio
news:OajGz8D7EHA.3836@.tk2msftngp13.phx.gbl
> Is it possible to set DATADIR=\\<company_network_somedirectory>\?
> When I try it, set-up seems to fail.
>
it is possible, using a trace flag, but strongly not suggested... SQL Server
requires a strong, reliant and trusted, verified path (and enough permission
must be granted to the Windows account running it's services) in order
perform (possibly as fast as possible) disk IO operations...
as Network share usually are not that secure and robust, nor fast, it is
strongly advised only to use "local" storag subsystem and not remote...
as regard the setup.exe parameter, I actually do not know if it's possible
to specify remote paths...
please keep you data on your local disk(s) :D

> Also, if I were to create a new database on a default instance of
> MSDE, I am not able to pick mapped network directories.
>
again, enough permission(s) [on the network shares] must be granted to the
Windows account running MSDE SQL Server and SQL Server Agent services..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank you, Andrea, for your reply. I shall follow it.
Andrea Montanari wrote:
> hi Sha,
> "Sha S." <shajihans@.ttnus.com> ha scritto nel messaggio
> news:OajGz8D7EHA.3836@.tk2msftngp13.phx.gbl
>
> it is possible, using a trace flag, but strongly not suggested... SQL Server
> requires a strong, reliant and trusted, verified path (and enough permission
> must be granted to the Windows account running it's services) in order
> perform (possibly as fast as possible) disk IO operations...
> as Network share usually are not that secure and robust, nor fast, it is
> strongly advised only to use "local" storag subsystem and not remote...
> as regard the setup.exe parameter, I actually do not know if it's possible
> to specify remote paths...
> please keep you data on your local disk(s) :D
>
>
> again, enough permission(s) [on the network shares] must be granted to the
> Windows account running MSDE SQL Server and SQL Server Agent services..
>
|||hi Sha,
"Sha S." <pilgrim216@.gmail.com> ha scritto nel messaggio
news:e8MrtIP7EHA.3616@.TK2MSFTNGP11.phx.gbl
> Thank you, Andrea, for your reply. I shall follow it.
>
:D
just a consideratio I had after posting... for sure it's not possible to
specify remote folders for <DATA_DIR> parameter as you can not install MSDE
specifying the trace flag required for that kind of feature
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply