SQL 2000 Back-up on a network drive

Posted on 2011-05-02
Last Modified: 2012-05-11
I am trying to back up to a network drive and getting th following error

Server: Msg 3201, Level 16, State 1, Line 1 Cannot open backup device 'E:\pubs.dat'. Device error or device off-line. See the SQL Server error log for more details. Server: Msg 3013, Level 16, State 1, Line 1 Backup or restore operation terminating abnormally.

I have done what is described in this article

any other suggestions?

Question by:ubsmail
    LVL 6

    Expert Comment

    so your sql server is now running under an account that has access to the network share?

    Can you access E:\ in your explorer?

    Perhaps the sql agent also needs this account?
    LVL 17

    Expert Comment

    If this is a mapped drive then your SQL Server will need to be logged in with an account with access to your E: drive when you take the backup.

    Author Comment

    Perhaps the sql agent also needs this account?

    Under the services tab I made sure SQL logged in under the proper account.

    How do make sure the agent is using that same account?
    LVL 17

    Expert Comment

    No, SQL Agent shouldn't need any special rights as long as your server is logged in with an account that maps your E: drive.
    LVL 21

    Expert Comment

    by:Alpesh Patel
    To create backup file, first map destination folder as network drive and use it as local drive after map.

    nothing more other than this.
    LVL 17

    Accepted Solution

    PatelAlpesh - There is more than that.  Drive mappings only persist when the account that created the mapping is logged in, hence, why I have told the OP that the server must also be logged in with an account that maps the E: drive.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now