00:00000:00001:2009/02/20 12:06:13.03 server Checking external objects.
00:00000:00001:2009/02/20 12:06:13.17 server Deallocating text/image data for external object 'P_REMEDY'.
00:00000:00001:2009/02/20 12:06:13.19 server Starting diagnostics for read failure:
00:00000:00001:2009/02/20 12:06:13.19 server Device Information:
Device number = 3
Phyname = \\.\E:
00:00000:00001:2009/02/20 12:06:13.19 server Buffer Information:
Buf addr = 0x2A855988, Mass addr = 0x2A855988
Buf pageno = 49921, Mass pageno = 49921, dbid = 4
00:00000:00001:2009/02/20 12:06:13.19 server
Buf virtpg = 50381569, Mass virtpg = 50381569
Buf stat = 0x1, Mass stat = 0x1008
Mass keep = 1, Mass awaited = 0
00:00000:00001:2009/02/20 12:06:13.19 server Page Information from first read attempt: Page read from disk ppageno = 49921, pobjid = 282484085, pindid = 2 pnextpg = 49921, pprevpg = 49921 plevel = 10, pstat = 0x8008 pts_hi = 17, pts_lo = -786839925
00:00000:00001:2009/02/20 12:06:13.19 server Page Information from second read attempt: Page read from disk ppageno = 49921, pobjid = 282484085, pindid = 2 pnextpg = 49921, pprevpg = 49921 plevel = 10, pstat = 0x8008 pts_hi = 17, pts_lo = -786839925
00:00000:00001:2009/02/20 12:06:13.19 server SDES Information:
dbid = 4, objid = 21, scur.pageid = 49921
sstat = 0x2000041, sstat2 = 0x40000
suid = 1, cacheid = 0
00:00000:00001:2009/02/20 12:06:13.19 server PSS Information:
pstat = 0x1000, pcurdb = 4, pspid = 1
p2stat = 0x1110, p3stat = 0x804
plasterror = 0, preverror = 0, pattention = 0
00:00000:00001:2009/02/20 12:06:13.19 server End diagnostics for read failure:
00:00000:00001:2009/02/20 12:06:13.19 server Run the DBCC command 'dbcc tablealloc' for both the objects 21, 282484085
00:00000:00001:2009/02/20 12:06:13.19 server Error: 605, Severity: 21, State: 1
00:00000:00001:2009/02/20 12:06:13.19 server An attempt was made to fetch logical page '49921' in database 'pharmwork' from cache 'default data cache'. Page belongs to object with id '282484085', not to object 'sysattributes'.
00:00000:00001:2009/02/20 12:06:13.19 kernel ************************************
00:00000:00001:2009/02/20 12:06:13.19 kernel SQL causing error : use master
00:00000:00001:2009/02/20 12:06:13.19 kernel ************************************
00:00000:00001:2009/02/20 12:06:13.19 server SQL Text: use master
00:00000:00001:2009/02/20 12:06:13.19 kernel curdb = 4 tempdb = 2 pstat = 0x1000
00:00000:00001:2009/02/20 12:06:13.19 kernel lasterror = 605 preverror = 0 transtate = 0
00:00000:00001:2009/02/20 12:06:13.19 kernel curcmd = 0 program =
00:00000:00001:2009/02/20 12:06:13.55 kernel Symbolic stack trace information is successfully loaded
00:00000:00001:2009/02/20 12:06:13.55 kernel pc: 0x00D343C8 os_get_cur_stk_desc+ 0x170 (0x70FFE5DC, 0x7C5C2160, 0x7C5721F0, 0xFFFFFFFF)
00:00000:00001:2009/02/20 12:06:13.55 kernel pc: 0x00D343C8 os_get_cur_stk_desc+ 0x170 (0x70FFE5DC, 0x70FFE394, 0x0000270F, 0x00000002)
00:00000:00001:2009/02/20 12:06:13.55 kernel pc: 0x00D08A3F pcstkwalk+ 0x31e (0x00040004, 0x00000002, 0x0000270F, 0x00000000)
00:00000:00001:2009/02/20 12:06:13.55 kernel pc: 0x00D085AF ucstkgentrace+ 0x25f (0x00040004, 0x00000001, 0x70FFF680, 0x01597B44)
00:00000:00001:2009/02/20 12:06:13.55 kernel pc: 0x00C98A2B ucbacktrace+ 0xab (0x00000000, 0xFFFFFFFF, 0x70FFEE84, 0x004896DF)
00:00000:00001:2009/02/20 12:06:13.55 kernel pc: 0x00408C95 terminate_process+ 0xeef (0x70FFEEA4, 0x00DA15A6, 0x00000006, 0x00000005)
00:00000:00001:2009/02/20 12:06:13.55 kernel pc: 0x004896FC close_network+ 0xc (0x00000006, 0x00000005, 0x00000015, 0x00000001)
00:00000:00001:2009/02/20 12:06:13.55 kernel pc: 0x004896DF hdl_default+ 0x38 (0x00000006, 0x00000005, 0x00000015, 0x00000001)
00:00000:00001:2009/02/20 12:06:13.55 kernel pc: 0x00DA15A6 omni_backout+ 0x76 (0x00000006, 0x00000005, 0x00000015, 0x00000001)
00:00000:00001:2009/02/20 12:06:13.55 kernel pc: 0x00489306 ex_raise+ 0x311 (0x2A855988, 0x02E95724, 0x00000001, 0x00000001)
00:00000:00001:2009/02/20 12:06:13.55 kernel pc: 0x00651D9F wrongpage+ 0xa71 (0x02E95724, 0x00000004, 0x00000000, 0x00000000)
00:00000:00001:2009/02/20 12:06:13.55 kernel pc: 0x0064F0EC getpage_with_validation+ 0x157c (0x02E95724, 0x70FFF21C, 0x00000004, 0x00000000)
00:00000:00001:2009/02/20 12:06:13.55 kernel pc: 0x00650138 getpage_noscan_with_validation+ 0x136 (0x00000000, 0x02E95724, 0x0000C301, 0x70FFF680)
00:00000:00001:2009/02/20 12:06:13.55 kernel pc: 0x00528E61 gettxtpage+ 0x414 (0x70FFF614, 0x02E95724, 0x70FFF9F8, 0x01597B44)
00:00000:00001:2009/02/20 12:06:13.55 kernel [Handler pc: 0x0053742A text_handler installed by the following function:-]
00:00000:00001:2009/02/20 12:06:13.55 kernel pc: 0x0052D40E deletetext+ 0x285 (0x02E94F1C, 0x03C65024, 0x03F1603C, 0x02C43CC0)
00:00000:00001:2009/02/20 12:06:13.55 kernel [Handler pc: 0x00DA1530 omni_backout installed by the following function:-]
00:00000:00001:2009/02/20 12:06:13.55 kernel pc: 0x00D916C9 omni_text_free+ 0x537 (0x02C4E440, 0x70FFFAD8, 0x006FBEA0, 0x02C4E440)
00:00000:00001:2009/02/20 12:06:13.55 kernel [Handler pc: 0x00DA1530 omni_backout installed by the following function:-]
00:00000:00001:2009/02/20 12:06:13.55 kernel pc: 0x00D92215 omni_text_recover+ 0x4e5 (0x02C4E440, 0x0000310B, 0x00000001, 0x00000001)
00:00000:00001:2009/02/20 12:06:13.57 kernel pc: 0x0041B431 dso_text_recover+ 0x15 (0x03F16000, 0x00000001, 0x00000000, 0x00000000)
00:00000:00001:2009/02/20 12:06:13.57 kernel pc: 0x006FBEA0 boot__recover_and_online+ 0x705 (0x03F16000, 0x70FFFBE8, 0x00000002, 0x004F29BE)
00:00000:00001:2009/02/20 12:06:13.57 kernel [Handler pc: 0x00708FD4 rec__caller_hdlr installed by the following function:-]
00:00000:00001:2009/02/20 12:06:13.57 kernel pc: 0x006FE0FE rec__boot_recover_dbs+ 0x3b6 (0x03F16000, 0x70FFFBE8, 0x70FFFE8A, 0x00000001)
00:00000:00001:2009/02/20 12:06:13.57 kernel pc: 0x006F9F49 rec_run_parallel_recovery+ 0xbf0 (0x00000001, 0x02C3E900, 0x022BF2C0, 0x00000000)
00:00000:00001:2009/02/20 12:06:13.57 kernel [Handler pc: 0x00708FD4 rec__caller_hdlr installed by the following function:-]
00:00000:00001:2009/02/20 12:06:13.57 kernel pc: 0x006FD897 dorecover+ 0x1a2 (0x00000000, 0x005C0039, 0x00680053, 0x00000000)
00:00000:00001:2009/02/20 12:06:13.57 kernel pc: 0x0040CC78 ds__recoverdbs+ 0xb06 (0x00000000, 0x005C0039, 0x00680053, 0x03C01E9C)
00:00000:00001:2009/02/20 12:06:13.57 kernel pc: 0x00406774 dsinit+ 0x1834 (0x03C01E9C, 0x005C0039, 0x00680053, 0x03C01E9C)
00:00000:00001:2009/02/20 12:06:13.57 kernel pc: 0x00C8D487 kpntwrapper+ 0x84 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00001:2009/02/20 12:06:13.57 kernel pc: 0x7C57B3BC KERNEL32.dll (0xBD830000, 0xFFFFFE94, 0x68217421, 0x0120218C)
00:00000:00001:2009/02/20 12:06:13.57 kernel pc: 0x7C57B958 KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00001:2009/02/20 12:06:13.57 kernel end of stack trace, spid 1, kpid 262148, suid 0
00:00000:00001:2009/02/20 12:06:13.58 server Recovery has restored the value of 'local async prefetch limit' for '16K' pool in 'default data cache' from '80' to 'DEFAULT'.
00:00000:00001:2009/02/20 12:06:13.58 server Recovery has restored the value of 'local async prefetch limit' for '2K' pool in 'default data cache' from '80' to 'DEFAULT'.
..... и все ... т.е. типа висит ......

Поднял .... вопрос закрыт