how to take backup of a database of sql server hosted on server!

Posted by Coolbharat under ASP.NET on 3/8/2014 | Points: 10 | Views : 806 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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.

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