Add mapped drive to list of drives to back up to | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Add mapped drive to list of drives to back up to

In SQL Server 2000 EM, how do I add a mapped drive to the list of drives available to back up to? I think this is a permissions issue and seems to center around the account and priveleges under which MSSQLSERVER service runs?
Thank you,
Michael
I haven’t come across this scenario before, as it is always advisable to take backup to local machine first and then copy to remote location. I would start the SQL Server service in some user account which has permissions on remote drive. Else, the backup process will fail. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
<br />Pretty sure you’d have to use UNC paths, and as gaurav said ensure that the sql server/agent service account has permissions to write to that path.<br /><br />Mapped drives require the user to be logged in… You could perhaps try loggin in with the SQLServer service account, mapping the drive setting reconnect at logon on, and then restart SQLServer/Agent. This may possibly give you access to the mapped drive (but I wouldn’t hold my breath… <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /> )<br /><br />Cheers<br />Twan
And its ideal to backup the database to the local file and copy across to the network drive which will save the resources with less impact. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
<br />yes definitely less impact to restore locally, although sometimes unacceptable to have the disk backup on the same machine as the databases (depending on the powers-that-be <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /> )<br /><br />Cheers<br />Twan
Twan I would like to hear those unacceptable terms to backup database locally. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Well I did it before .
I maped a drive on SQL server to other computer.
The server always had the same user loged
and i was backing up to that direction.
I remember i couldn’t browse to choose that file so i just wrote a path manually.
This wasn’t a good idea thought:to write to different computer
Yes by all means its not a good practice to maintain backups.
BTW< what is the size of database and userbase in the current situation? _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>