• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 354
  • Last Modified:

SQL 2000 Back-up on a network drive

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 http://support.microsoft.com/kb/207187

any other suggestions?

1 Solution
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?
Chris MangusDatabase AdministratorCommented:
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.
ubsmailAuthor Commented:
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?
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Chris MangusDatabase AdministratorCommented:
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.
Alpesh PatelAssistant ConsultantCommented:
To create backup file, first map destination folder as network drive and use it as local drive after map.

nothing more other than this.
Chris MangusDatabase AdministratorCommented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now