Re: Back up on remote computer.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

Date: Wed, 22 Sep 2004 00:21:25 -0700

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: 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: 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)
  • Re: Format and Reinstall
    ... Do you have a backup copy of the C: ... may be possible to decrypt the files, based on a KB article on the MS site. ... > access the encrypted files. ...
    (microsoft.public.windowsxp.security_admin)
  • Re: BACKUPS - allowing anyone to perform one
    ... SQL Server MVP ... > perform a backup from within a stored procedure. ... > RECONFIGURE WITH OVERRIDE ...
    (microsoft.public.sqlserver.security)
  • Re: Problems Backing Up
    ... Check out the BACKUP command. ... >> can you post those commands here? ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)