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 |
|
Tracey
Starting Member
40 Posts |
 Posted - 2004-06-20 : 21:26:08
|
| Hello everyone,when i tried to open "Current Activity" in the Enterprise Manager it throwing the Error:Error 1222: Lock Request Time Out Period ExceededI found that there are 2 jobs(optimizations, log backup)have been running for more than 2 days.I couldnt able to stop the JOBS using Enterprise Manager.I can able to access the Database using Query Analayzer.Any help/Advice much appreciated.Thanks in advanceTracey |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-06-21 : 00:32:51
|
| I would be inclined to restart SQL "For Good Measure" in case it has got into a muddle.And take a look at the size of all LDF files, and check that you have enough free space on the disk.If the LDF files are large then they probably aren't getting cleared down - either because transaction backups aren't running, or databases need to be set to SIMPLE instead of FULL.Kristen |
 |
|
|
|
|
|
Need Help. "Error 1222: Lock Request Time Out Peri