Back up on remote computer.

We have 5 computer (peer-to-peer).
SQL Serve is intalled on one machine. I want to do the
backup (put the backup files) on remote machine but it
doesn't show the network drives. It just shows the local
drives.
How can I do the backup on remote machine?HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/?kbid=555128
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:01be01c4a00d$b3c7a0c0$a401280a@.phx.gbl...
> We have 5 computer (peer-to-peer).
> SQL Serve is intalled on one machine. I want to do the
> backup (put the backup files) on remote machine but it
> doesn't show the network drives. It just shows the local
> drives.
> How can I do the backup on remote machine?|||Backup to the fully-qualified UNC name rather than a mapped drive letter.
For example: \\machine_name\share\backups. The mapped drives visible to you
on your machine won't necessarily be available to SQL Server.
--
David Portas
SQL Server MVP
--|||Good one, Geoff,. Short and straight to the point.
(The MS disclaimer is probably more text than the actual KB. :-) )
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:eZ9$YLBoEHA.2096@.TK2MSFTNGP15.phx.gbl...
> HowTo: Backup to UNC name using Database Maintenance Wizard
> http://support.microsoft.com/?kbid=555128
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> <anonymous@.discussions.microsoft.com> wrote in message
> news:01be01c4a00d$b3c7a0c0$a401280a@.phx.gbl...
>> We have 5 computer (peer-to-peer).
>> SQL Serve is intalled on one machine. I want to do the
>> backup (put the backup files) on remote machine but it
>> doesn't show the network drives. It just shows the local
>> drives.
>> How can I do the backup on remote machine?
>|||The MSDN Article you mentioned/wrote says:
"1) The SQL Server service must be running under a domain-
level account."
My questions are:
(1) How do I know whether my SQL Server service is running
under a domain-level account or not?
(2) All our computers are in a Workgroup. What steps
should I take to start the SQL Server service to run under
domain-level account.
Our SQL Server is Standard Edition and version is 2000
SP3a.
>--Original Message--
>HowTo: Backup to UNC name using Database Maintenance
Wizard
>http://support.microsoft.com/?kbid=555128
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
><anonymous@.discussions.microsoft.com> wrote in message
>news:01be01c4a00d$b3c7a0c0$a401280a@.phx.gbl...
>> We have 5 computer (peer-to-peer).
>> SQL Serve is intalled on one machine. I want to do the
>> backup (put the backup files) on remote machine but it
>> doesn't show the network drives. It just shows the local
>> drives.
>> How can I do the backup on remote machine?
>
>.
>|||Comments Inline
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:346801c4a020$e318d6b0$a501280a@.phx.gbl...
> The MSDN Article you mentioned/wrote says:
> "1) The SQL Server service must be running under a domain-
> level account."
> My questions are:
> (1) How do I know whether my SQL Server service is running
> under a domain-level account or not?
>
Look under the Services applet in Control Panel for the SQL Server service
(MSSQLSERVER) or Enterprise manager Properties page Security tab. A
domain-level account is one that authenticates as Domain_Name\LoginName
> (2) All our computers are in a Workgroup. What steps
> should I take to start the SQL Server service to run under
> domain-level account.
I haven't tried this in a workgroup. It might work if you have a login and
password that is the same on both servers that you run the SQL service
under. The other option is to create a domain.
> Our SQL Server is Standard Edition and version is 2000
> SP3a.
>
> >--Original Message--
> >HowTo: Backup to UNC name using Database Maintenance
> Wizard
> >http://support.microsoft.com/?kbid=555128
> >
> >--
> >Geoff N. Hiten
> >Microsoft SQL Server MVP
> >Senior Database Administrator
> >Careerbuilder.com
> >
> >I support the Professional Association for SQL Server
> >www.sqlpass.org
> >
> ><anonymous@.discussions.microsoft.com> wrote in message
> >news:01be01c4a00d$b3c7a0c0$a401280a@.phx.gbl...
> >> We have 5 computer (peer-to-peer).
> >>
> >> SQL Serve is intalled on one machine. I want to do the
> >> backup (put the backup files) on remote machine but it
> >> doesn't show the network drives. It just shows the local
> >> drives.
> >>
> >> How can I do the backup on remote machine?
> >
> >
> >.
> >|||Thanks. There seemed to be a need for something to explain how to do this.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uYgKQsBoEHA.3460@.tk2msftngp13.phx.gbl...
> Good one, Geoff,. Short and straight to the point.
> (The MS disclaimer is probably more text than the actual KB. :-) )
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:eZ9$YLBoEHA.2096@.TK2MSFTNGP15.phx.gbl...
> > HowTo: Backup to UNC name using Database Maintenance Wizard
> > http://support.microsoft.com/?kbid=555128
> >
> > --
> > Geoff N. Hiten
> > Microsoft SQL Server MVP
> > Senior Database Administrator
> > Careerbuilder.com
> >
> > I support the Professional Association for SQL Server
> > www.sqlpass.org
> >
> > <anonymous@.discussions.microsoft.com> wrote in message
> > news:01be01c4a00d$b3c7a0c0$a401280a@.phx.gbl...
> >> We have 5 computer (peer-to-peer).
> >>
> >> SQL Serve is intalled on one machine. I want to do the
> >> backup (put the backup files) on remote machine but it
> >> doesn't show the network drives. It just shows the local
> >> drives.
> >>
> >> How can I do the backup on remote machine?
> >
> >
>|||We have 5 machines. First machine Windows 2000 Server (SQL
Server 2000 Standard is installed here). Rest of the
machines have Windows 2000 Pro.
Keep the above scenario in mind, could you explain me what
you wrote earlier:
>It might work if you have a login and password that is
> the same on both servers that you run the SQL service
>under. The other option is to create a domain.|||OK. Create a login on the SQL host computer. Put it in the local
administrators group on that machine. Change the SQL Service to run under
that login. Create a login on the backup target machine with the exact same
username and password. Grant that login full control over the file share
and the NTFS folder you want to back up to. No guarantees, but this may
work in a workgroup.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:426701c4a023$dc891f50$a301280a@.phx.gbl...
> We have 5 machines. First machine Windows 2000 Server (SQL
> Server 2000 Standard is installed here). Rest of the
> machines have Windows 2000 Pro.
> Keep the above scenario in mind, could you explain me what
> you wrote earlier:
> >It might work if you have a login and password that is
> > the same on both servers that you run the SQL service
> >under. The other option is to create a domain.
>|||On Windows 2000 Server Machine the SQLServer Services are
running under Administrator. Also on the other computer
(windows 2000 professional) login is administrator (and
obviously has all rights on the shared folder).
This doesn't work when I try to backup on that shared
folder. The error says that location of the (backup) file
cannot be verified..do u want to continue...and when I
say YES then after a couple of seconds the backup process
stops."
SO does this CONCLUDE that this is not possible in
Workgroup scenario?
Thank you.
>--Original Message--
>OK. Create a login on the SQL host computer. Put it in
the local
>administrators group on that machine. Change the SQL
Service to run under
>that login. Create a login on the backup target machine
with the exact same
>username and password. Grant that login full control
over the file share
>and the NTFS folder you want to back up to. No
guarantees, but this may
>work in a workgroup.
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
><anonymous@.discussions.microsoft.com> wrote in message
>news:426701c4a023$dc891f50$a301280a@.phx.gbl...
>> We have 5 machines. First machine Windows 2000 Server
(SQL
>> Server 2000 Standard is installed here). Rest of the
>> machines have Windows 2000 Pro.
>> Keep the above scenario in mind, could you explain me
what
>> you wrote earlier:
>> >It might work if you have a login and password that is
>> > the same on both servers that you run the SQL service
>> >under. The other option is to create a domain.
>
>.
>|||Do the Administrator account have the same password on the two machines?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<anonymous@.discussions.microsoft.com> wrote in message
news:36e801c4a05b$6dd83310$a501280a@.phx.gbl...
> On Windows 2000 Server Machine the SQLServer Services are
> running under Administrator. Also on the other computer
> (windows 2000 professional) login is administrator (and
> obviously has all rights on the shared folder).
> This doesn't work when I try to backup on that shared
> folder. The error says that location of the (backup) file
> cannot be verified..do u want to continue...and when I
> say YES then after a couple of seconds the backup process
> stops."
> SO does this CONCLUDE that this is not possible in
> Workgroup scenario?
> Thank you.
> >--Original Message--
> >OK. Create a login on the SQL host computer. Put it in
> the local
> >administrators group on that machine. Change the SQL
> Service to run under
> >that login. Create a login on the backup target machine
> with the exact same
> >username and password. Grant that login full control
> over the file share
> >and the NTFS folder you want to back up to. No
> guarantees, but this may
> >work in a workgroup.
> >
> >--
> >Geoff N. Hiten
> >Microsoft SQL Server MVP
> >Senior Database Administrator
> >Careerbuilder.com
> >
> >I support the Professional Association for SQL Server
> >www.sqlpass.org
> >
> ><anonymous@.discussions.microsoft.com> wrote in message
> >news:426701c4a023$dc891f50$a301280a@.phx.gbl...
> >> We have 5 machines. First machine Windows 2000 Server
> (SQL
> >> Server 2000 Standard is installed here). Rest of the
> >> machines have Windows 2000 Pro.
> >>
> >> Keep the above scenario in mind, could you explain me
> what
> >> you wrote earlier:
> >>
> >> >It might work if you have a login and password that is
> >> > the same on both servers that you run the SQL service
> >> >under. The other option is to create a domain.
> >>
> >
> >
> >.
> >|||Yes.
>--Original Message--
>Do the Administrator account have the same password on
the two machines?
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
><anonymous@.discussions.microsoft.com> wrote in message
>news:36e801c4a05b$6dd83310$a501280a@.phx.gbl...
>> On Windows 2000 Server Machine the SQLServer Services
are
>> running under Administrator. Also on the other computer
>> (windows 2000 professional) login is administrator (and
>> obviously has all rights on the shared folder).
>> This doesn't work when I try to backup on that shared
>> folder. The error says that location of the (backup)
file
>> cannot be verified..do u want to continue...and when I
>> say YES then after a couple of seconds the backup
process
>> stops."
>> SO does this CONCLUDE that this is not possible in
>> Workgroup scenario?
>> Thank you.
>> >--Original Message--
>> >OK. Create a login on the SQL host computer. Put it
in
>> the local
>> >administrators group on that machine. Change the SQL
>> Service to run under
>> >that login. Create a login on the backup target
machine
>> with the exact same
>> >username and password. Grant that login full control
>> over the file share
>> >and the NTFS folder you want to back up to. No
>> guarantees, but this may
>> >work in a workgroup.
>> >
>> >--
>> >Geoff N. Hiten
>> >Microsoft SQL Server MVP
>> >Senior Database Administrator
>> >Careerbuilder.com
>> >
>> >I support the Professional Association for SQL Server
>> >www.sqlpass.org
>> >
>> ><anonymous@.discussions.microsoft.com> wrote in message
>> >news:426701c4a023$dc891f50$a301280a@.phx.gbl...
>> >> We have 5 machines. First machine Windows 2000
Server
>> (SQL
>> >> Server 2000 Standard is installed here). Rest of the
>> >> machines have Windows 2000 Pro.
>> >>
>> >> Keep the above scenario in mind, could you explain
me
>> what
>> >> you wrote earlier:
>> >>
>> >> >It might work if you have a login and password
that is
>> >> > the same on both servers that you run the SQL
service
>> >> >under. The other option is to create a domain.
>> >>
>> >
>> >
>> >.
>> >
>
>.
>|||Are you using an UNC path or a mapped drive?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<anonymous@.discussions.microsoft.com> wrote in message
news:12fb01c4a074$c5073190$a601280a@.phx.gbl...
> Yes.
> >--Original Message--
> >Do the Administrator account have the same password on
> the two machines?
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >http://www.karaszi.com/sqlserver/default.asp
> >http://www.solidqualitylearning.com/
> >
> >
> ><anonymous@.discussions.microsoft.com> wrote in message
> >news:36e801c4a05b$6dd83310$a501280a@.phx.gbl...
> >> On Windows 2000 Server Machine the SQLServer Services
> are
> >> running under Administrator. Also on the other computer
> >> (windows 2000 professional) login is administrator (and
> >> obviously has all rights on the shared folder).
> >>
> >> This doesn't work when I try to backup on that shared
> >> folder. The error says that location of the (backup)
> file
> >> cannot be verified..do u want to continue...and when I
> >> say YES then after a couple of seconds the backup
> process
> >> stops."
> >>
> >> SO does this CONCLUDE that this is not possible in
> >> Workgroup scenario?
> >>
> >> Thank you.
> >>
> >> >--Original Message--
> >> >OK. Create a login on the SQL host computer. Put it
> in
> >> the local
> >> >administrators group on that machine. Change the SQL
> >> Service to run under
> >> >that login. Create a login on the backup target
> machine
> >> with the exact same
> >> >username and password. Grant that login full control
> >> over the file share
> >> >and the NTFS folder you want to back up to. No
> >> guarantees, but this may
> >> >work in a workgroup.
> >> >
> >> >--
> >> >Geoff N. Hiten
> >> >Microsoft SQL Server MVP
> >> >Senior Database Administrator
> >> >Careerbuilder.com
> >> >
> >> >I support the Professional Association for SQL Server
> >> >www.sqlpass.org
> >> >
> >> ><anonymous@.discussions.microsoft.com> wrote in message
> >> >news:426701c4a023$dc891f50$a301280a@.phx.gbl...
> >> >> We have 5 machines. First machine Windows 2000
> Server
> >> (SQL
> >> >> Server 2000 Standard is installed here). Rest of the
> >> >> machines have Windows 2000 Pro.
> >> >>
> >> >> Keep the above scenario in mind, could you explain
> me
> >> what
> >> >> you wrote earlier:
> >> >>
> >> >> >It might work if you have a login and password
> that is
> >> >> > the same on both servers that you run the SQL
> service
> >> >> >under. The other option is to create a domain.
> >> >>
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >|||I am using UNC path.
>--Original Message--
>Are you using an UNC path or a mapped drive?
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
><anonymous@.discussions.microsoft.com> wrote in message
>news:12fb01c4a074$c5073190$a601280a@.phx.gbl...
>> Yes.
>> >--Original Message--
>> >Do the Administrator account have the same password on
>> the two machines?
>> >
>> >--
>> >Tibor Karaszi, SQL Server MVP
>> >http://www.karaszi.com/sqlserver/default.asp
>> >http://www.solidqualitylearning.com/
>> >
>> >
>> ><anonymous@.discussions.microsoft.com> wrote in message
>> >news:36e801c4a05b$6dd83310$a501280a@.phx.gbl...
>> >> On Windows 2000 Server Machine the SQLServer
Services
>> are
>> >> running under Administrator. Also on the other
computer
>> >> (windows 2000 professional) login is administrator
(and
>> >> obviously has all rights on the shared folder).
>> >>
>> >> This doesn't work when I try to backup on that
shared
>> >> folder. The error says that location of the (backup)
>> file
>> >> cannot be verified..do u want to continue...and
when I
>> >> say YES then after a couple of seconds the backup
>> process
>> >> stops."
>> >>
>> >> SO does this CONCLUDE that this is not possible in
>> >> Workgroup scenario?
>> >>
>> >> Thank you.
>> >>
>> >> >--Original Message--
>> >> >OK. Create a login on the SQL host computer. Put
it
>> in
>> >> the local
>> >> >administrators group on that machine. Change the
SQL
>> >> Service to run under
>> >> >that login. Create a login on the backup target
>> machine
>> >> with the exact same
>> >> >username and password. Grant that login full
control
>> >> over the file share
>> >> >and the NTFS folder you want to back up to. No
>> >> guarantees, but this may
>> >> >work in a workgroup.
>> >> >
>> >> >--
>> >> >Geoff N. Hiten
>> >> >Microsoft SQL Server MVP
>> >> >Senior Database Administrator
>> >> >Careerbuilder.com
>> >> >
>> >> >I support the Professional Association for SQL
Server
>> >> >www.sqlpass.org
>> >> >
>> >> ><anonymous@.discussions.microsoft.com> wrote in
message
>> >> >news:426701c4a023$dc891f50$a301280a@.phx.gbl...
>> >> >> We have 5 machines. First machine Windows 2000
>> Server
>> >> (SQL
>> >> >> Server 2000 Standard is installed here). Rest of
the
>> >> >> machines have Windows 2000 Pro.
>> >> >>
>> >> >> Keep the above scenario in mind, could you
explain
>> me
>> >> what
>> >> >> you wrote earlier:
>> >> >>
>> >> >> >It might work if you have a login and password
>> that is
>> >> >> > the same on both servers that you run the SQL
>> service
>> >> >> >under. The other option is to create a domain.
>> >> >>
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>.
>|||That is strange. I just did exactly that. I have a workgroup, and SQL Server is running under a
service account that also exists on the other machine, having the same password on both machines. I
executed below command, and it worked perfectly:
BACKUP DATABASE pubs TO DISK = '\\TibMedia\C\pubs.bak'
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<anonymous@.discussions.microsoft.com> wrote in message
news:3b8001c4a0ad$30389f20$a501280a@.phx.gbl...
>I am using UNC path.
>>--Original Message--
>>Are you using an UNC path or a mapped drive?
>>--
>>Tibor Karaszi, SQL Server MVP
>>http://www.karaszi.com/sqlserver/default.asp
>>http://www.solidqualitylearning.com/
>>
>><anonymous@.discussions.microsoft.com> wrote in message
>>news:12fb01c4a074$c5073190$a601280a@.phx.gbl...
>> Yes.
>> >--Original Message--
>> >Do the Administrator account have the same password on
>> the two machines?
>> >
>> >--
>> >Tibor Karaszi, SQL Server MVP
>> >http://www.karaszi.com/sqlserver/default.asp
>> >http://www.solidqualitylearning.com/
>> >
>> >
>> ><anonymous@.discussions.microsoft.com> wrote in message
>> >news:36e801c4a05b$6dd83310$a501280a@.phx.gbl...
>> >> On Windows 2000 Server Machine the SQLServer
> Services
>> are
>> >> running under Administrator. Also on the other
> computer
>> >> (windows 2000 professional) login is administrator
> (and
>> >> obviously has all rights on the shared folder).
>> >>
>> >> This doesn't work when I try to backup on that
> shared
>> >> folder. The error says that location of the (backup)
>> file
>> >> cannot be verified..do u want to continue...and
> when I
>> >> say YES then after a couple of seconds the backup
>> process
>> >> stops."
>> >>
>> >> SO does this CONCLUDE that this is not possible in
>> >> Workgroup scenario?
>> >>
>> >> Thank you.
>> >>
>> >> >--Original Message--
>> >> >OK. Create a login on the SQL host computer. Put
> it
>> in
>> >> the local
>> >> >administrators group on that machine. Change the
> SQL
>> >> Service to run under
>> >> >that login. Create a login on the backup target
>> machine
>> >> with the exact same
>> >> >username and password. Grant that login full
> control
>> >> over the file share
>> >> >and the NTFS folder you want to back up to. No
>> >> guarantees, but this may
>> >> >work in a workgroup.
>> >> >
>> >> >--
>> >> >Geoff N. Hiten
>> >> >Microsoft SQL Server MVP
>> >> >Senior Database Administrator
>> >> >Careerbuilder.com
>> >> >
>> >> >I support the Professional Association for SQL
> Server
>> >> >www.sqlpass.org
>> >> >
>> >> ><anonymous@.discussions.microsoft.com> wrote in
> message
>> >> >news:426701c4a023$dc891f50$a301280a@.phx.gbl...
>> >> >> We have 5 machines. First machine Windows 2000
>> Server
>> >> (SQL
>> >> >> Server 2000 Standard is installed here). Rest of
> the
>> >> >> machines have Windows 2000 Pro.
>> >> >>
>> >> >> Keep the above scenario in mind, could you
> explain
>> me
>> >> what
>> >> >> you wrote earlier:
>> >> >>
>> >> >> >It might work if you have a login and password
>> that is
>> >> >> > the same on both servers that you run the SQL
>> service
>> >> >> >under. The other option is to create a domain.
>> >> >>
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>>
>>.