Networks

Ask something
Question Locked

Error - SQL Server Backup Error

0 helpful
10 replies

by andrewchristiandc

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hey gang,

I'm trying to backup a SQL Server 2000 database using the Enterprise Manager. I've done this before without problems. For some reason, when I'm trying to back it up on Friday it gives me an error:

"Cannot open backup device 'C:\file location'. Dvice error or device off-line. See SQL-Server error log for more details. Backup database terminating abnormally."

Obviously, my computer can access it's own C drive! Another database on the same service is backing up to the C drive just fine. I've fiddled a lil' bit with the settings on the backup wizard without result. Can anyone help?? Please??
Thanks!!!111

10 replies

by tony hopkinson

Can you rename the file? If you get locked by another user...
If it does will it then work, possibly permissions, on that thought what user contect is the backup job running as , same one as the working one?

The other thing you could try is a verify on the existing file.

by steve.ingle

JAT,

Do you have a backup device defined?
Are you trying to back up to disk, or to a defined backup device?

Steve

by andrewchristiandc

I do have a backup device defined, I think. The other databases from the same instance of the database engine are backing up (successfully) onto the C: drive. I'll check those settings for you.

by andrewchristiandc

xx Thanks for your help! The problem was that I needed to delete some of the old backup locations on the device list that had gotten out of date. They were mapped to folders on my drive that were no longer there. Now everything is working great. Thanks again!!

--!

by andrewchristiandc

Thanks for your help! The problem was that I needed to delete some of the old backup locations on the device list that had gotten out of date. They were mapped to folders on my drive that were no longer there. Now everything is working great. Thanks again!!

--!

by chitownjerry

Remember.. YOU are not doing the backup.. the account that runs SQL Server is doing the backup.
First off.. are you at the server itself, or does SQL reside on a different computer? If it's on a different computer, it will attempt to backup to it's own "c:\file location", NOT yours. Every path is relative to SQL server, not your machine. That is the most likely cause of your problem.

If SQL is on the machine you are on, then it may not have access to "c:\file location".

Good luck,
Jerry

by andrewchristiandc

oo

Thanks for your help! The problem was that I needed to delete some of the old backup locations on the device list that had gotten out of date. They were mapped to folders on my drive that were no longer there. Now everything is working great. Thanks again!!

--!

This discussion is closed to new replies.