1. 614 error on a user database and 806 error on tempdb seen in the error log
Hi,
We have a production SQLServer 6.5 running with service pack SP5a
update:
I got the following 2 errors.....
1.
Error : 806, Severity: 21, State: 1
Could not find virtual page for logical page 67833121 in database
'tempdb' database 'tempdb'
2.
I got error when I ran a job for Update statistics
Error : 614, Severity: 21, State: 3
A row on page 2697653 was accessed that has an illegal length of -8631
in database 'abc'.
For Error 2: I ran update statistics using query analyser. It is fine
Is there anything I have to do further?
For Error 1 : The work around given by Microsoft
=================================================
I ran
DBCC CHECKTABLE(syslogs)
I am getting the following message on :
master:
Checking syslogs
The total number of data pages in this table is 1.
*** NOTICE: Notification of log space used/free cannot be reported
because the log segment is not on its own device.
Table has 11 data rows.
DBCC execution completed. If DBCC printed error messages, see your
System Administrator.
model:
Checking syslogs
The total number of data pages in this table is 47.
*** NOTICE: Notification of log space used/free cannot be reported
because the log segment is not on its own device.
Table has 532 data rows.
DBCC execution completed. If DBCC printed error messages, see your
System Administrator.
tempdb:
Checking syslogs
The total number of data pages in this table is 1.
*** NOTICE: Notification of log space used/free cannot be reported
because the log segment is not on its own device.
Table has 31 data rows.
DBCC execution completed. If DBCC printed error messages, see your
System Administrator.
I ran dbcc checkdb on master,model and tempdb . Still I get the same
problem.
for tempdb:
Checking 8
The total number of data pages in this table is 1.
*** NOTICE: Notification of log space used/free cannot be reported
because the log segment is not on its own device.
Table has 19 data rows.
for master:
Checking 8
The total number of data pages in this table is 1.
*** NOTICE: Notification of log space used/free cannot be reported
because the log segment is not on its own device.
Table has 27 data rows.
for model:
Checking 8
The total number of data pages in this table is 47.
*** NOTICE: Notification of log space used/free cannot be reported
because the log segment is not on its own device.
Table has 532 data rows.
All system databases and userdatabase recovered successfully when I
restarted sqlserver.
Please advice how to get rid of this problem.
Thanks in advance,
Anu
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
2. "Insert" performance over distributed servers
3. Error 22030: A MAPI error (error number: 271) occurred
4. Hiding the Surrogate Key in the display
5. Generate an error to an error log on a stored procedure error
6. Paradox Engine: 'Blob modified by another user'
7. DTS Error-2147217887 (80040E21) Error string: Errors occurred
8. ??? New INGRES features ???
9. Error 22030: AMAPI error (error number: 16389) occured
10. UGRGENT: VB4 DAO - Error 31037 Error Loading from File DAO Error 3251
11. Error: Error while trying to retrive text for error
12. SYSTEM ERROR: seek error - Error 163
13. Help! Error 17832, Error 17824, Error 1608, Error 232, Error 109