Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 0 down vote favorite

What would be the syntax to backup MS SQL Database 2005 to a network drive?

share|improve this question

1 Answer

up vote 0 down vote accepted

You cannot map the network share to a drive letter.

Try one of these options:

  1. Directly type the UNC path of the server where you would like to backup /restore from [Eg: type \\servername\Sharename\Filename.bak in the 'Locate database files' dialog's 'File name' text box]
  2. Create a backup device pointing to the UNC path. Then backup to this device.

--

EDIT:

I tried both methods and they work. Make sure your MSSQLSERVER service is running under an account with permissions to write to the network path you're trying to get to.

share|improve this answer
Backup Database Prod_10 to disk = '\\backup\Prod_10.bak' i tried this an is nor working getting error operating system error 3 ( the system can find the path ) I have map a drive on the server – Kam Mar 29 '11 at 21:52
I said you can't do it with a mapped drive. Did you even try the suggestions in my answer? – Randolph West Mar 29 '11 at 22:00
i tried that. my servername is backup have a folder call ProdBack Here is the syntax i used Backup database Prod_10 to disk = '\\backup\ProdBack\Prod_10.bak' – Kam Mar 29 '11 at 22:07
See my updated answer. Check your SQL Service is running under the correct permissions to write to the network share. – Randolph West Mar 30 '11 at 0:36
Yes please. I think it was permission issues. – Kam Mar 30 '11 at 1:14
show 2 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.