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-02-26 : 07:44:27
|
| Kramer Zoltan writes "Hi.im looking for some help.Im working on MSSQL database and i have problems. 1: MSSQL7 is installed on Win2k on a HP Net server with 4Gb memory and dual CPU and NETRaid HDD. 2: i have a big database with 1-10 mil records and serv over 200 user.3: the problem is: MSSQL stop working 2-3 times pro weak and block all the Windows.last time event log errors:AT 23/02/2003 02:2918210 :BackupMedium::ReportIoError: write failure on backup device 'J:\UTFORG_Backup\utforg_db_200302230200.BAK'. Operating system error 1453(Insufficient quota to complete the requested service.).-----------------------AT 23/02/2003 02:30SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'utforg Plan by FM'' (0xBE2A72439048704F8F251124A2C71EA4) - Status: Failed - Invoked on: 23.02.2003 02:00:02 - Message: The job failed. The Job was invoked by Schedule 7 (Schedule 1). The last step to run was step 1 (Step 1). ----------------------AT 23/02/2003 03:06:04844 :Time out occurred while waiting for buffer latch type 1, bp 0x14210b00, page (1:5), stat 0xb, object ID 2:1:0, waittime 500. Continuing to wait.----------------------At this time the Windows do not answering to remote administration (PcAnywhere).AT 23/02/2003 03:06:44844 :Time out occurred while waiting for buffer latch type 2, bp 0x14210b00, page (1:5), stat 0xb, object ID 2:1:0, waittime 500. Continuing to wait.--------------------AT 23/02/2003 03:07:05Error: 845, Severity: 17, State: 1Time out occurred while waiting for buffer latch type 1 for page (1:5), database ID 2, object ID 1, index ID 0. AT 23/02/2003 03:15:00 to 06:01:45 repeated 21 times844 :Time out occurred while waiting for buffer latch type 2, bp 0x14210b00, page (1:5), stat 0xb, object ID 2:1:0, waittime 1000. Continuing to wait.The Windows at this time are dead.I try to login localy but no succes.Is it any type of patch or SP for this problem ?? PS: this is one of my problems with SQL 7. some times it stop working and i dont have event log messages to understud the problem.Please help.Tanks." |
|
|
chadmat
The Chadinator
1974 Posts |
|
|
|
|
|
|
|
help MSSQL error. 