Skip to Content
0

cannot open backup device operating system error 3

Dec 13, 2016 at 07:25 AM

306

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Luis Darui
Dec 15, 2016 at 11:44 AM
0

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.

Show 5 Share
10 |10000 characters needed characters left characters exceeded

Luis,

In that link it is given that EXEC xp_cmdshell ‘net use <drivename> <share name>’ to be executed in query prompt.

I given as per below image. But still it is showing "network path cannot be found"

Kindly help me on this urgent situation

Regards

Praveen

ip.jpg (16.6 kB)
0

You have to check the user that runs the SQL Server services. Do that by checking the SQL Server Configuration Manager. If you don't have a Domain user running the service, you cannot access network shares.

You have to use a Domain user, add this domain user access to this network share with write authorizations. By doing it you will have to restart SQL Server. This will allow you to map a network Path.

Have you checked the blog I've sent you?

1

Luis,

I tried many times. But i couldn't able to take the same to a network location. After that i connected one HDD and completed my backup

Regards

Praveen

0

Luis,

I'll try one more time. By the way can u tell me how to check the logged in user which i am using is Domain user or not?

Regards

Praveen

0

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

1
Raghavendra Rao Noothangi Dec 23, 2016 at 09:15 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Martin Winn Dec 29, 2016 at 12:28 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded