Re: Back up on remote computer.

Tech-Archive recommends: Fix windows errors by optimizing your registry

anonymous_at_discussions.microsoft.com
Date: 09/22/04 

Date: Wed, 22 Sep 2004 07:05:17 -0700

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.
>> >> >>
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>
>.
>

Relevant Pages

  • RE: File Adapter race condition
    ... Two fairly powerful machines reading from a common ... Or rather if you use UNC path ... > because of our file receive adapter is very efficient at picking up the ... On powerful, faster machines, this problem is more pronounced. ...
    (microsoft.public.biztalk.general)
  • Re: Need to purge vulnerable gdiplus.dll?
    ... > On several machines, I'm still seeing a vulnerable version of ... Even stranger, if you check the very same file using a UNC path, the versions come out the same. ... Explorer properties through UNC reports: ...
    (NT-Bugtraq)
  • User on a different domain accessing printer
    ... another office who need access to our shared printers when they come to ... The other users' machines are on Domain B and use Windows 2000 OS. ... if I try the adding a printer using the UNC path using a Win XP ... Does anyone know a way to get round this and where the problem lies? ...
    (microsoft.public.win2000.setup)
  • Re: Can you setup an ActiveActivePassive Cluster on 64 bit SQL Svr 2
    ... Yes, So you have 3 machines, with 2 instances, each running on their own ... Just a normal cluster setup will work, and once you have installed both ... Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Backups to different server
    ... Microsoft SQL Server MVP ... UNC path and make sure that the SQLService has full access to the ...
    (microsoft.public.sqlserver.setup)