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

Posted by Coolbharat under Sql Server on 3/10/2014 | Points: 10 | Views : 1384 | Status : [Member] | Replies : 1
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'


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


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


Mark This Response as Answer

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

Login to post response