Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Joozh
Posting Yak Master
145 Posts |
 Posted - 2005-04-20 : 00:55:10
|
| 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. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-04-20 : 01:21:19
|
| And what did the SQL Server error log reveal to you? Look at that and the SQL Server servers event viewer. Post all related errors in the Event Viewer Application, Security, and System logs with the error in the SQL Server error log. It could be anything from hardware going bad to someone changing permissions on you with what you've given us.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
Joozh
Posting Yak Master
145 Posts |
Posted - 2005-04-20 : 01:52:49
|
| Thanks for the reply. The funny thing is that I am able to backup the database to any other folder. The more funny part is that I have the same rights on all other folders as compared to the folder where the original backup was supposed to be placed.Does this give any clues? Is the following the information you have asked me to post. I looked it up by going to 'Event Viewer' and then 'Application log' and then looked at the entry which had a red cross. Is this correct or should I be looking else where?BACKUP failed to complete the command BACKUP DATABASE [Sales] TO DISK = N'D:\Backup\Sales' WITH INIT , NOUNLOAD , NAME = N'Sales backup', NOSKIP , STATS = 10, NOFORMAT DECLARE @i INTselect @i = position from msdb..backupset where database_name='Sales'and type!='F' and backup_set_id=(s |
|
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-20 : 11:29:03
|
| Have you tried deleting the backup file? If not, copy the 'D:\Backup\Sales' file to another location and then delete the original file. It may be having problems accessing that file.Also, has it always run without a file extension? |
|
|
|
Joozh
Posting Yak Master
145 Posts |
Posted - 2005-04-21 : 00:44:47
|
| My sincere thanks to everyone for your help and replies.I found the reason for the problem. in D:\Backup\ i had created a subfolder by the name of Sales and the name of my backup file (which was to be places in d:\Backup\ was also sales....This was creating the problemand I had totally forgotten about the sub-folder that I had created :(Anyway, I changed the name of the backup file from Sales to Sales.bak and things are okay now.Regards. |
|
|
|
|
|
|
|
|
Error while trying to backup a database