cannot open backup device operating system error 3

[former_member183044]

Hi all,

I am in a problematic situation right now.

I was trying to take the full backup of my DB via MS SQL to a network location. That network location was already mapped to my system. But when i tried the full backup, i was facing the error message "cannot open backup device operating system error 3" .

When i searched i found that that particular location has to also map to SQL. For that i done the following command

exec xp_cmdshell 'net use X: (XXX.XXX.XXX.XX)\Backup'

go

but after this message also i am facing the same error.

Kindly help me in this situation.

Awaiting your earliest reply

Regards

Praveen

[former_member197667]

Hi There,

The other way that you can deal with this situation of taking backup on to network drive is by MS SQL management studio.

All you need to do is to create new backup device. Check the below mentioned link.

https://msdn.microsoft.com/en-us/library/ms189109.aspx

You can find this device in SAP and you can create a backup job to this newly created backup device with immediate execution.

Kind regards,

Raghavendra