We have developed problems with the Emerald db. Every time I try run
Maint. tasks on the Emerald db the process goes so far and then, CPU time
goes to 100% and will sit there for hours. The db seems to work, however,
it complains every time I try to save a record.
Here is an snip from the error log.
Last good backup was a few days ago. I could restore, but would rather
not.
I would be eternally grateful to anyone whp could help!
Thanks in advance.
JOhn :}
97/05/19 22:56:44.68 spid5
[WARNING] RA_AsyncReadioComplete() found circular page chain, page:0xe9ec,
dbid:6, objid:0x67f3781c should be:0x67f3781c.97/05/19 22:56:44.68 spid5
[RA DEBUG] status:0x87 alloc_map:0xff ioflags:1
Referenced page 59884 has PREV of 59883 and was pointed to by Page 59885
Page linkage failed for INDID 3; Processed 247 pages;
97/05/19 22:56:46.41 spid5
[WARNING] RA_AsyncReadioComplete() found circular page chain, page:0x56e0,
dbid:6, objid:0x67f3781c should be:0x67f3781c.97/05/19 22:56:46.41 spid5
[RA DEBUG] status:0x187 alloc_map:0xff ioflags:1
Referenced page 22240 has PREV of 52655 and was pointed to by Page 22241
Page linkage failed for INDID 4; Processed 587 pages;
97/05/19 22:56:48.87 spid14 DBCC TRACEOFF 3605, SPID 14
97/05/19 22:57:05.91 spid5
[WARNING] RA_AsyncReadioComplete() found circular page chain, page:0xe9ec,
dbid:6, objid:0x67f3781c should be:0x67f3781c.97/05/19 22:57:05.91 spid5
[RA DEBUG] status:0x107 alloc_map:0xff ioflags:1
97/05/19 23:04:46.04 kernel SQL Server terminating because of system
shutdown
97/05/19 23:04:46.04 kernel LogEvent: Failed to report the current event;
operating system error = 31(A device attached to the system is not
functioning.)
John C. Lange, Sr. PALACE dot NET, INC.
microjl@palacenet.net MICRO-TECH Computers!
608.742.1601 & 6980 2800 New Pinery Road, Suite 10
http://www.palacenet.net/ Portage, WI 53901
http://www.microt.com/
--- __o
--- _-\<,_ FASTEST SERVICE IN TOWN
--- (_)/ (_)