Re: Backup to Network Drive

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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@xxxxxxxxxxxx

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Kevin" <kevgrim@xxxxxxxxx> wrote in message
news:u9IoaX4uFHA.2948@xxxxxxxxxxxxxxxxxxxxxxx
> 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@xxxxxxxxxxxx> wrote in message
> news:OKetdH4uFHA.1560@xxxxxxxxxxxxxxxxxxxxxxx
>> 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@xxxxxxxxxxxx
>>
>> MVP Program: http://www.microsoft.com/mvp
>>
>> Blog: http://www.msmvps.com/epprecht/
>>
>> "Kevin" <kevgrim@xxxxxxxxx> wrote in message
>> news:%23ZmdjA4uFHA.2312@xxxxxxxxxxxxxxxxxxxxxxx
>>> 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.
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: sbs 2003 network slow why?
    ... Issue: Local Account Password Test ... SQL Server and/or MSDE authentication mode is set to Windows Only. ... The Everyone group does not have more than Read access to the SQL Server and/or MSDE registry keys. ... BUILTIN\Administrators group should not be part of sysadmin role. ...
    (microsoft.public.windows.server.sbs)
  • Re: Error 0x80070534 when changing service account
    ... The only solution that I have been able to find for this error is to RDP into the SQL Server using the new Service account you want the SQL server to run under. ... prefix, an error 0x80070056 "The specified network password is not correct." ...
    (microsoft.public.sqlserver.security)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)