Hi,
I am asked to take back up programmatically by using asp.net of a database in sql server.I was successful in creating .BAK file of a database and restoring it on the sql server installed on my machine.But when i connect to the sql server hosted on server and try to take backup of a database it does give errors.
in sql server management studio
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.