This has been a funny week. things that were running just fine till last week (and for the last many months) have started giving problems despite that I have not changed any settings.

The problem is that one of my scheduled jobs has started failing. The job used to simply takle a backup of a database. When I tried to probe into it and tried to manually take the backup (via Enterprise Manager..) I get a dialog box with the message:

Cannot open backup device 'D:\Backup\Sales'. Device error or device off-line.See the SQL server error log for more details.
Backup database is terminating abnormally.



Can someone kindly guide me how to solve this.

Many TIA.