Skip to Content

cannot open backup device operating system error 3

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 15, 2016 at 11:44 AM

    Hi Praveen,

    It is not a best practice to let a service access network.

    In case you really need this, there is a blog that explain how to do this:

    https://blogs.msdn.microsoft.com/sqlserverfaq/2009/02/27/how-to-backup-sql-server-databases-to-a-mapped-drive/

    Keep in mind: you should use a domain account to run the SQL Server services, otherwise you would have to allow a computer account to access the remote shared folder, which can be really messy.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Praveen,

      If you look in the Services applet on your server console, and find the SQL Server (MSSQLSERVER) service, check the Log On As column for that service (or drill into the properties of the service and check the Log On tab). If you are using a domain account, it will appear as something like <DOMAIN>/<USER>. If it's a local computer account, instead of your domain you'll see the local server hostname. Or, more likely, you'll see one of the "built-in" accounts, such as Local System. If SQL Server is running as Local System, then you won't be able to access mapped network drives until you change that.

      Cheers,
      Matt

  • avatar image
    Former Member
    Dec 23, 2016 at 09:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 29, 2016 at 12:28 PM

    Hi Praveen,

    have you tried to use UNC names instead?

    The user running the database (not the user you're logged on with) must be permitted to connect to the remote server. you have to configure the share on the remote system and give permissions.

    Kind regards,

    Martin

    Add comment
    10|10000 characters needed characters exceeded