Re: Backup Sql database to mapped network drive on another server prob

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 01/28/05 

Date: Fri, 28 Jan 2005 17:10:27 -0500

It's not just one way to do it , it is the recommended way to do it. What
you see as a user means nothing unless that account is the same one that SQL
Server runs under. It is that account that does the backup regardless of
who initiates it or how they initiate the backup. Mapped drives can easily
get blown away or become unusable when changes are made on either end. So
if you want to continue using a mapped drive (which no one will recommend)
you need to log on to the server (database server) under the account that
sql server is running under and make sure the drive is mapped properly and
it still has the correct permissions to see and write to that share. If not
then the backup can not work properly. 

-- 
Andrew J. Kelly  SQL MVP
"BarbS" <BarbS@discussions.microsoft.com> wrote in message 
news:4FFF5A0E-3592-428D-A732-58378275F3D2@microsoft.com...
>I understand that's one way to do it and I appreciate your answer. As I 
>said
> earlier, I was backing up to a network drive manually and through the
> maintenance. I have been doing this for the last 6 months. Something got
> change and I don't know where to start. Any suggestions as to what I can 
> take
> a look  would be appreciated.
>
>
> "BarbS" wrote:
>
>> Until recently (stopped working this week) I have been able to backup my 
>> sql
>> database (on a windows 2000 server) to a mapped network drive(mapped to
>> another 2000 server). I am a user on both servers (administrator). I can 
>> see
>> the the drive in explorer. I can access the files.
>>
>> I cannot see the drive in enterprise manager. Can someone help? Thanks.

Relevant Pages

  • Re: NAS or USB Backup?
    ... Has anyone tried putting a second NIC in the server and putting the NAS on ... If I wasn't so cheap, I'd buy boxed drives instead of OEM, and I'd learn ... What you do to restore individual files is to "mount" the ... ShadowProtect backup - any full or incremental backup you choose. ...
    (microsoft.public.windows.server.sbs)
  • Re: NAS or USB Backup?
    ... I have considered doing it with a member server. ... If I wasn't so cheap, I'd buy boxed drives instead of OEM, and I'd learn ... What you do to restore individual files is to "mount" the ... ShadowProtect backup - any full or incremental backup you choose. ...
    (microsoft.public.windows.server.sbs)
  • Re: Access Denied trying to do quick editing
    ... It cannot save files to mapped drives. ... Server has the ASPX files on a local drive ... IIS is configured to map URL to the local ASPX files via a local ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Access Denied trying to do quick editing
    ... It cannot save files to mapped drives. ... Server has the ASPX files on a local drive ... IIS is configured to map URL to the local ASPX files via a local ...
    (microsoft.public.inetserver.iis)
  • Re: SBS 2008 Backup - restore utility?
    ... If you've already installed a fresh copy of SBS 2008 on another server, ... the Recovery Wizard in Windows Server Backup to recover files and folders ... On the Specify location type window, choose "Local drives" and clik ...
    (microsoft.public.windows.server.sbs)
Loading