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