Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Map Network drive not visibile for backup? Expand / Collapse
Author
Message
Posted Friday, October 11, 2013 11:42 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 5:15 AM
Points: 1,049, Visits: 2,956
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
Post #1504181
Posted Saturday, October 12, 2013 3:26 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 5:15 AM
Points: 1,049, Visits: 2,956

For database backup taking on network dirve, Is it really require to enable XP_CMDSHELL feature in instance side? there may be security issues
Post #1504188
Posted Saturday, October 12, 2013 1:25 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, November 28, 2013 10:20 PM
Points: 45, Visits: 309
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
Post #1504228
Posted Sunday, October 13, 2013 10:23 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:58 PM
Points: 36,794, Visits: 31,253
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1504276
Posted Sunday, October 13, 2013 2:06 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:20 PM
Points: 112, Visits: 802
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
Post #1504288
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse