Backup to Network Drive

Am trying to backup to a network drive as the other machine has loads of
space.
Am using:-
BACKUP database TO DISK='\\myserver\backup\database.bak'
Keep getting backup device not available, when can see it via Network Places
etc.
Am using Windows 2000 Pro on both machines.
Hi
The SQL Server service account needs to be a domain account, and must have
rights on the destination share.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kevin" <kevgrim@.tesco.net> wrote in message
news:%23ZmdjA4uFHA.2312@.TK2MSFTNGP14.phx.gbl...
> Am trying to backup to a network drive as the other machine has loads of
> space.
> Am using:-
> BACKUP database TO DISK='\\myserver\backup\database.bak'
> Keep getting backup device not available, when can see it via Network
> Places etc.
> Am using Windows 2000 Pro on both machines.
>
|||Thanks Mike
The PC has rights to the other one.
Am not sure what you mean by a domain account as am only using peer to peer
networking.
Kevin
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OKetdH4uFHA.1560@.TK2MSFTNGP09.phx.gbl...
> Hi
> The SQL Server service account needs to be a domain account, and must have
> rights on the destination share.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kevin" <kevgrim@.tesco.net> wrote in message
> news:%23ZmdjA4uFHA.2312@.TK2MSFTNGP14.phx.gbl...
>
|||Hi
OK. Then you need to setup SQL Server to use a local account that exists on
your machine. The same local account must exist on the other PC too, with
exactly the same password.
You change the account the SQL Server uses to login through Enterprise
Manager, Server Properties, Security Tab.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kevin" <kevgrim@.tesco.net> wrote in message
news:u9IoaX4uFHA.2948@.TK2MSFTNGP15.phx.gbl...
> Thanks Mike
> The PC has rights to the other one.
> Am not sure what you mean by a domain account as am only using peer to
> peer networking.
> Kevin
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:OKetdH4uFHA.1560@.TK2MSFTNGP09.phx.gbl...
>
|||But since you are using MSDE, Start > Control Panel > Services, modify the
Service Account startup for your MSDE installation there.
The account must be local administrator on both machines.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:eIfkjp4uFHA.3000@.TK2MSFTNGP12.phx.gbl...
> Hi
> OK. Then you need to setup SQL Server to use a local account that exists
> on your machine. The same local account must exist on the other PC too,
> with exactly the same password.
> You change the account the SQL Server uses to login through Enterprise
> Manager, Server Properties, Security Tab.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kevin" <kevgrim@.tesco.net> wrote in message
> news:u9IoaX4uFHA.2948@.TK2MSFTNGP15.phx.gbl...
>
|||hi Kevin
Kevin wrote:
> Thanks Mike
> The PC has rights to the other one.
> Am not sure what you mean by a domain account as am only using peer
> to peer networking.
just a side note on Mike indications... all this works becouse of the
underlying OS gets somehow confused and a sort of "embezzlement" where 2
differents accounts, YourPC\YourAccount and OtherPC\YourAccount "share" a
kind of uniqueness becouse of netbios intrusion... a preventive netbios
connection, even on a share or using NET USE can help...
but this is not granted to work in future releases or even OS service
packs...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Not true - the user does NOT need to be administrator on both machines. If
you run SQL Server under the Local System account, it never has any network
credentials and cannot access either UNC paths or shared drives. But if you
run SQL Server as any other user, you can see the network (although you may
have to make this account a local administrator for it to run).
If you can set your remote machine up so that you can see the share (which
doesn't necessarily mean a matching username or password - you may be able
to allow access to "Everyone" or "Anonymous Logon" or "Guest"), you don't
even need an account on the remote machine. You certainly don't need an
administrator account there.
Ideally you should apply the principle of least privilege - run SQL Server
under an account with the least privilege it needs to do its job, then
create a matching account on the remote machine with access just to the
share.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%2359rIB5uFHA.2396@.TK2MSFTNGP14.phx.gbl...
> But since you are using MSDE, Start > Control Panel > Services, modify the
> Service Account startup for your MSDE installation there.
> The account must be local administrator on both machines.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:eIfkjp4uFHA.3000@.TK2MSFTNGP12.phx.gbl...
>