Hi,
I have a Wíndows 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,
OlafHi,
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 Wíndows 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
> 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 Wíndows 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,
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
> 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
> > 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 Wíndows 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,
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...
> 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
> > 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
> > > 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 Wíndows 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,
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
> 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...
> > 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
> > > 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
> > > > 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 Wíndows 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
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
)