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

Posted by Coolbharat under Sql Server on 3/10/2014 | Points: 10 | Views : 1575 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

Latest Posts