ubsmail
asked on
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?
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?
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.
ASKER
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?
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?
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.
To create backup file, first map destination folder as network drive and use it as local drive after map.
nothing more other than this.
nothing more other than this.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Can you access E:\ in your explorer?
Perhaps the sql agent also needs this account?