I have a Wndows 2003 server running SQL Server (SP 3a).
My problem: Neither via Enterprise Manager nor T-SQL is it possible to do a
backup / restore on a mapped network drive. Using Query Analyzer, an error
shows up saying "Backup medium <xyz> cannot be opened. Media error or medium
offline", using Enterprise Manager, no network drive is being shown at all.
Strange enough, it is possible to list and access all network drives in the
(file-) explorer from this server. I do not consider this to be a security
issue, as the sql server runs under the domain administrator's account
having all required permissions. The network drives are assigned to
different servers, all of which belong to the same domain as the sql server.
The domain administrator is permanently logged on the sql server so the
network drives are present all the time.
It makes no difference if I run the Enterprise Manager directly on the sql
server or from a different machine. It also makes no difference if the
connection to the sql server is established using Integrated Security or sql
server's sa account.
There is another sql server in our domain which is configured identically,
apart from running under Win 2000 Server. This one has no problems accessing
any network drives...
For different reasons I do want to use a mapped drive instead of an UNC
path, so I hope someone can help me
)Thanks in advance,
Olaf
Hi,
Start the SQL Server service using a Domain user which has got rights in
remote server share. After that you will be able to access the remot path
from query analyzer.
backup database dbname to disk='\\remoteserver\backupshare\dbname.bak' with
init
Note:-
Enterprise manager will not show the mapped drives
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a Wndows 2003 server running SQL Server (SP 3a).
> My problem: Neither via Enterprise Manager nor T-SQL is it possible to do
a
> backup / restore on a mapped network drive. Using Query Analyzer, an error
> shows up saying "Backup medium <xyz> cannot be opened. Media error or
medium
> offline", using Enterprise Manager, no network drive is being shown at
all.
> Strange enough, it is possible to list and access all network drives in
the
> (file-) explorer from this server. I do not consider this to be a security
> issue, as the sql server runs under the domain administrator's account
> having all required permissions. The network drives are assigned to
> different servers, all of which belong to the same domain as the sql
server.
> The domain administrator is permanently logged on the sql server so the
> network drives are present all the time.
> It makes no difference if I run the Enterprise Manager directly on the sql
> server or from a different machine. It also makes no difference if the
> connection to the sql server is established using Integrated Security or
sql
> server's sa account.
> There is another sql server in our domain which is configured identically,
> apart from running under Win 2000 Server. This one has no problems
accessing
> any network drives...
> For different reasons I do want to use a mapped drive instead of an UNC
> path, so I hope someone can help me
)> Thanks in advance,
> Olaf
>
|||Hari,
thanks for the quick reply, but:
the sql server account does have full permissions as it is the domain admin
account. Also, I do not want to use an UNC path, but a mapped drive. The
other sql server I mentioned does show the mapped drives in Enterprise
Manager.
Anyway, thx
Olaf
"Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Start the SQL Server service using a Domain user which has got rights in
> remote server share. After that you will be able to access the remot path
> from query analyzer.
> backup database dbname to disk='\\remoteserver\backupshare\dbname.bak'
with[vbcol=seagreen]
> init
> Note:-
> Enterprise manager will not show the mapped drives
>
> --
> Thanks
> Hari
> MCDBA
> "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
do[vbcol=seagreen]
> a
error[vbcol=seagreen]
> medium
> all.
> the
security[vbcol=seagreen]
> server.
sql[vbcol=seagreen]
> sql
identically,
> accessing
>
|||Hi,
Can you try this from query analyzer:-
xp_cmdshell 'net use k: \\remoteserver\share'
(No need of specifying user name and password , becuase u are starting sql
server in domain admin user)
The above command will map the drive k:, now try
Backup database dbname to disk='k:\dbname.bak' with init
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:e0jYRTtUEHA.2504@.TK2MSFTNGP11.phx.gbl...
> Hari,
> thanks for the quick reply, but:
> the sql server account does have full permissions as it is the domain
admin[vbcol=seagreen]
> account. Also, I do not want to use an UNC path, but a mapped drive. The
> other sql server I mentioned does show the mapped drives in Enterprise
> Manager.
> Anyway, thx
> Olaf
> "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
path[vbcol=seagreen]
> with
> do
> error
in[vbcol=seagreen]
> security
the[vbcol=seagreen]
> sql
or[vbcol=seagreen]
> identically,
UNC
>
|||Hi,
yes, this works fine, thanks.
Anyway, I am wondering why the other sql server in our domain can access the
mapped drives without doing anything. Maybe this is a bug ..?
Thanks,
Olaf
"Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:uBh4gbtUEHA.556@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Hi,
> Can you try this from query analyzer:-
> xp_cmdshell 'net use k: \\remoteserver\share'
> (No need of specifying user name and password , becuase u are starting sql
> server in domain admin user)
> The above command will map the drive k:, now try
> Backup database dbname to disk='k:\dbname.bak' with init
> --
> Thanks
> Hari
> MCDBA
> "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> news:e0jYRTtUEHA.2504@.TK2MSFTNGP11.phx.gbl...
> admin
in[vbcol=seagreen]
> path
to[vbcol=seagreen]
or[vbcol=seagreen]
at[vbcol=seagreen]
> in
account[vbcol=seagreen]
> the
the[vbcol=seagreen]
the[vbcol=seagreen]
Security
> or
> UNC
>
|||Hi,
Thats good. I am not sure about the error.
Are you running this command from server or from a client PC using a Query
analyzer. If it is client PC you need to
map the drive from query analyzer. If you are executing from server that
command is suppose to work directly.
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:espbrftUEHA.1036@.TK2MSFTNGP12.phx.gbl...
> Hi,
> yes, this works fine, thanks.
> Anyway, I am wondering why the other sql server in our domain can access
the[vbcol=seagreen]
> mapped drives without doing anything. Maybe this is a bug ..?
> Thanks,
> Olaf
> "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:uBh4gbtUEHA.556@.tk2msftngp13.phx.gbl...
sql[vbcol=seagreen]
The[vbcol=seagreen]
rights[vbcol=seagreen]
> in
disk='\\remoteserver\backupshare\dbname.bak'[vbcol=seagreen]
possible[vbcol=seagreen]
> to
an[vbcol=seagreen]
> or
shown[vbcol=seagreen]
> at
drives[vbcol=seagreen]
> account
to[vbcol=seagreen]
sql[vbcol=seagreen]
so[vbcol=seagreen]
> the
> the
> Security
an
>
