Map Network drive not visibile for backup?

Question

Map Network drive not visibile for backup?

SQL Galaxy

One Orange Chip

Points: 29472
More actions
October 11, 2013 at 11:42 pm

#299639

Hi,
I have mapped network drive for backup purpose. It is showing server level. But it is not visible in Management plan at chose backup drive location.. what could be issues?
SQL Agnet account - running under Network sercive account.
Error Messages:
Operating system error 3(The system cannot find the path specified.).
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Thanks
ananda

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 1

For database backup taking on network dirve, Is it really require to enable XP_CMDSHELL feature in instance side? there may be security issues

AJ@SQL SSC Eights! Points: 811 More actions · Answer 2

Agreed on xp_cmdshell. The very simple procedure is outlined here.

http://blogs.msdn.com/b/varund/archive/2009/06/04/backup-sql-server-database-to-a-share-drive-on-another-server.aspx

Jeff Moden SSC Guru Points: 1004434 More actions · Answer 3

ananda.murugesan (10/11/2013)
Hi,
I have mapped network drive for backup purpose. It is showing server level. But it is not visible in Management plan at chose backup drive location.. what could be issues?
SQL Agnet account - running under Network sercive account.
Error Messages:
Operating system error 3(The system cannot find the path specified.).
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Thanks
ananda

You don't need to see it in the GUI to use it. Just use the UNC for the backup path and it'll work just fine.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

sqlsurfing SSCarpal Tunnel Points: 4883 More actions · Answer 4

Hi Anada,

Does your service account has permission to the network share?

You should be able to navigate to the folder when you are logged into the server and confirm by checking the folder permissions/properties?

--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀