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 |
|
Kappy
Starting Member
30 Posts |
 Posted - 2001-12-04 : 10:05:53
|
| Hi-I have a SQL 6.5 server whose backups keep failing. The backup job is scheduled to run every night - but keeps returning and error that the device can't be opened because it is in use by another process. Up until today, when I ran the job manually, it worked fine. Now I am getting the same error when trying to run it manually. Any ideas on what could be causing this?Thanks. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2001-12-04 : 10:29:23
|
| Probably the device can't be opened because it is in use by another process.Maybe you were copying a previous backup to tape and it has left the file locked.Try deleting the backup file so that the backup creates a new one.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Backup failing