SQL 2000 Back-up on a network drive

Posted on 2011-05-02
Medium Priority
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 http://support.microsoft.com/kb/207187

any other suggestions?

Question by:ubsmail

Expert Comment

ID: 35507797
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

by:Chris Mangus
ID: 35507924
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

ID: 35508262
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?
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 17

Expert Comment

by:Chris Mangus
ID: 35508349
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
ID: 35511720
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

Chris Mangus earned 2000 total points
ID: 35512477
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
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.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

831 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