You can always backup to UNC path as long as the SQL Server's domain account has permissions. The mapped drive is a profile setting related to the server's account. That means that if you login the server as (i.e.) "Administrator" while the server runs as "SQLSRV", the server can't see the mapped drive (since it's not on its profile). One possible solution is to perform the map using the server's account. This could be done:
i) Login with the server account and create the map
ii) Run the `net use` command with `runas` while logged in as admin
iii) Run the `net use` in xp_cmdshell to create the map
Don't trust the GUI to show you the drive, always check with either T-SQL or by typing the path in the GUI (for mapped drives)
HTH
Anastasios Papadopoulos
Αναστάσιος Παπαδόπουλος
Software Solutions Architect
SalesManager Hellas
Customer Relationship Management Solutions
Τηλ.: (+30) 210 6083485
Φαξ: (+30) 210 6018453
Αγ. Ιωάννου 7, Αγ. Παρασκευή 153 42
e-mail: [Email address protected]
www.salesmanager.gr
-----Original Message-----
From: Jim Hill [mailto:mssqldba-ezmlmshield-x57515096.[Email address protected]
Sent: Tuesday, April 29, 2008 4:32 PM
To: LazyDBA Discussion
Subject: backup to network
Guru's
I was under the impression that when set up SQL to use a domain account to run SQL service and agent under SQL20005 that I would be able to backup a database to a network drive which I have mapped via explorer. When I try to backup a database this way from management studio, the mapped drive does appear as an option, only local drives are displayed for destinations of the backup.
any comment would be appreciated.
Jim
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page