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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-05 : 14:59:25
|
| Cheryl writes "Each night there are 3 databases that are backed-up (using the back-up tool), however, by the time the last database is backing up it always dies at about 90%. The only message that is generated is that the file has been locked by another process. The clincher is that there are no other processes running at this time and the first back-ups occur with no problems.What are some things to consider when troubleshooting?" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-05 : 15:04:18
|
| Are you writing to the same file? And are the backups happen at the same time? If yes and yes, then that's your problem. Backup your databases to different files and don't run them at the same time.Do you have a tape backup that runs at night? That could lock the file also.Tara |
 |
|
|
tonyshukal
Starting Member
7 Posts |
Posted - 2004-05-06 : 07:51:27
|
| Have you checked if second back is actually finished.I had some problems earlier in which Database is backed up but SQL Agent didn't released the file.SQL Agent has not released the backup files from 2nd backup when 3rd backup started.I think Tara is right about running backup at same place, same time. |
|
|
|
|
|
|
SQL 2000 Back-up error