Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2008
    Posts
    3

    Unanswered: cannot access database

    cannot access database. please help!

    00:00000:00001:2008/02/02 21:08:30.73 server Recovering database 'mydb'.
    00:00000:00001:2008/02/02 21:08:30.76 server Starting diagnostics for read fail
    ure:
    00:00000:00001:2008/02/02 21:08:30.77 server Device Information:
    Device number = 8
    Phyname = /data/mydb_prod/mydbdatadev
    00:00000:00001:2008/02/02 21:08:30.77 server Buffer Information:
    Buf addr = 0x5068965c, Mass addr = 0x5068965c
    Buf pageno = 114268, Mass pageno = 114268, dbid
    = 6
    00:00000:00001:2008/02/02 21:08:30.77 server
    Buf virtpg = 134331998, Mass virtpg = 134331998
    Buf stat = 0x1, Mass stat = 0x1008
    Mass keep = 1, Mass awaited = 0

    00:00000:00001:2008/02/02 21:08:30.77 server Page Information from first read a
    ttempt: Page read from disk ppageno = 114268, pobjid = 1680005985, pindid = 255
    pnextpg = 0, pprevpg = 0 plevel = 241, pstat = 0x4030 pts_hi = 0, pts_lo = 52098
    23
    00:00000:00001:2008/02/02 21:08:30.77 server Page Information from second read
    attempt: Page read from disk ppageno = 114268, pobjid = 1680005985, pindid = 255
    pnextpg = 0, pprevpg = 0 plevel = 241, pstat = 0x4030 pts_hi = 0, pts_lo = 5209
    823

    00:00000:00001:2008/02/02 21:08:30.77 server SDES Information:
    dbid = 6, objid = 8, scur.pageid = 114268
    sstat = 0x0, sstat2 = 0x4000000
    suid = 1, cacheid = 0
    00:00000:00001:2008/02/02 21:08:30.77 server PSS Information:
    pstat = 0x1000, pcurdb = 6, pspid = 1
    p2stat = 0x110, p3stat = 0x1000081e
    plasterror = 0, preverror = 0, pattention = 0

    00:00000:00001:2008/02/02 21:08:30.77 server End diagnostics for read failure:
    00:00000:00001:2008/02/02 21:08:30.77 server Run the DBCC command 'dbcc tableal
    loc' for both the objects 8, 1680005985
    00:00000:00001:2008/02/02 21:08:30.78 server Error: 605, Severity: 21, State: 1
    00:00000:00001:2008/02/02 21:08:30.78 server An attempt was made to fetch logic
    al page '114268' in database 'miasdb' from cache 'default data cache'. Page belo
    ngs to object with id '1680005985', not to object 'syslogs'.
    00:00000:00001:2008/02/02 21:08:30.80 server Error: 3414, Severity: 21, State:
    1
    00:00000:00001:2008/02/02 21:08:30.80 server Database 'mydb' (dbid 6): Recove
    ry failed. Check the SQL Server errorlog for further information as to the cause

  2. #2
    Join Date
    Feb 2008
    Posts
    3
    latest result

    Table Corrupt: Object id wrong; tables: alloc page 114176 extent id=114264 l page#=114268 objid in ext=1680005985 (name = cm_receipt) objid in page=1680005985 (name = cm_receipt) objid in sysindexes=8 (name = syslogs)

    please help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •