How to take BackUp of a Sql Server Database hosted remotely!

Posted by Coolbharat under Sql Server on 3/10/2014 | Points: 10 | Views : 1545 | Status : [Member] | Replies : 1
Hi,
I am asked to take backup of a database from sql server which is remotely hosted.In other words our company has sql server in shared hosting.Problem is that the BACKUP query doesn't act on that server whereas it acts fine in local server.Similarly we can't take BackUp or Generate Script from the database.

For example, when BACKUP query executed

backup database dbname to disk='d:\destination\script.bak'

Error

Cannot open backup device 'd:\destination\script.bak'. Operating system error 21(The device is not ready.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

I think we can't take BackUp in shared hosting environment.In that case how we will generate .BAK file or take BackUp of database.

Please Help me out on this.

Thanks in advance




Responses

Posted by: Bandi on: 3/10/2014 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Refer
http://stackoverflow.com/questions/3960257/cannot-open-backup-device-operating-system-error-5

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Coolbharat, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response