up vote 0 down vote favorite
share [g+] share [fb]

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

link|improve this question
feedback

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.

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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