Re: Back up on remote computer.

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 09/22/04 

Date: Wed, 22 Sep 2004 09:37:49 +0200

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: What type of Server Roles to assign for Backup and Recovery
    ... You just have to add it to the appropriate DB's within the server. ... SQL Server MVP ... I have created a Windows acc add in the Backup Operators Group..This gives u ... mgr,Then creating a SQL login in servers with sysadmin server roles cause ...
    (microsoft.public.sqlserver.security)
  • Re: Guru Needed for Two Tough Questions
    ... What you can do is login to the server as an Administrator and ... David Portas ... SQL Server MVP ...
    (microsoft.public.sqlserver)
  • Re: Problems Backing Up
    ... commands, and when something goes wrong, you find it more difficult to hunt down the problem. ... > I didnt have time last night to continue my exploration of the BACKUP ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: restoring dB and login to new server
    ... Tibor Karaszi, SQL Server MVP ... that looks like it would simplify things a bit...but I still need to create the login manually? ... databases between servers by doing a full backup, then restoring on the new ... database, I get an error that the "user or role already exists". ...
    (microsoft.public.sqlserver.tools)
  • Re: Moving a big database
    ... out SQL Lite Speed which will compress the backup as it's happening. ... > I too agree Tibers comments. ... > 20 Minutes and then Restore will take another 30 minutes. ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)