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 - 2003-08-21 : 08:09:17
|
| Tod writes "Hi,Can somebody give me a hint, this is a second morning that our database it's lock, I'm trying to see where is the Problem with sp_lock and I'm seeeng that we have lock up process with resource name: [BULK-OP-DB]. The Backup job it's starting at 02AM every day, and it's finished succsefully after one hour. I can't see that this is the reason even in the BOL refereer to these message: DB:db_id[BULK-OP-DB], which identifies the database lock taken by the backup database.Can somebody give me a hint, Please?Regards,Tod" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-21 : 12:54:36
|
| Are you performing the SQL Backup using SQL Server or some 3rd party software? One hour is a bit long for a database backup, how big is your database? And what do you mean by locked? Can anyone perform queries when the database is being backed up?Tara |
 |
|
|
|
|
|
Database Lock "BULK-OP-DB"