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 |
|
soonyu
Starting Member
13 Posts |
 Posted - 2008-09-14 : 21:28:30
|
| Time out occurred while waiting for buffer latch type 4,bp 0xff0180, page 7:25263), stat 0, object ID 7:0:0, EC 0x42BF40C0 : 6, waittime 300. Not continuing to wait.This happen after language_exec: Process 161 generated an access violation. SQL Server is terminating this process..and it dump error to sql log every few minutes.Any idea what should I do ?Cheers |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
soonyu
Starting Member
13 Posts |
Posted - 2008-09-14 : 21:36:59
|
| select @@version, and it show : Microsoft SQL Server 2000 - 8.00.2050 (Intel X86) Mar 7 2008 21:29:56 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-09-15 : 00:02:19
|
| Access violations are typically bugs in the SQL Server software. You are using a recent build of SQL Server 2000, so I'd contact Microsoft directly to find out if a fix exists for your issue. If the issue is found to be a bug, the call is free.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
soonyu
Starting Member
13 Posts |
Posted - 2008-09-15 : 03:09:00
|
| Thanks for help,Btw, Backup database and backup log is fail after the error occur. and log file getting largerDo you think restart database will help to solve this problem ? |
|
|
|
soonyu
Starting Member
13 Posts |
Posted - 2008-09-15 : 03:22:37
|
| and query start blocking by spid > 1000..don't know how spid_id > 1000 come from..wired.. |
|
|
|
|
|
|
Time out occurred while waiting for buffer latch