Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2002
    Location
    St. Louis
    Posts
    1

    Angry Unanswered: HELP With THIS MESSAGE

    This is what we are getting on the server but I cannot seem to find anything anywhere and i am not real strong in SQL...I am a server guy that is tasked with finding the issue!

    Scott H
    Weasel101

    Event Type: Error
    Event Source: MSSQLServer
    Event Category: Server
    Event ID: 17052
    Date: 3/12/2002
    Time: 2:45:06 PM
    User: ********** (Changed for privacy...sorry)
    Computer: MYCOMPUTER (Changed for privacy...sorry)
    Description:
    Error: 823, Severity: 24, State: 1
    I/O error (bad page ID) detected during read of BUF pointer = 0x1431e6c0, page ptr = 0x498f6000, pageid = (0x1:0x403), dbid = 4, status = 0x801, file = f:\MSSQL7\DATA\msdbdata.mdf.
    Data:
    0000: 37 03 00 00 18 00 00 00 7.......
    0008: 08 00 00 00 4e 00 54 00 ....N.T.
    0010: 30 00 30 00 33 00 32 00 0.0.3.2.
    0018: 4b 00 00 00 05 00 00 00 K.......
    0020: 6d 00 73 00 64 00 62 00 m.s.d.b.
    0028: 00 00 ..

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Do you know if this happened during a restore ???

  3. #3
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335

  4. #4
    Join Date
    Mar 2002
    Posts
    9
    CAUSE
    SQL Server may allow the log to be backed up when non-logged operations have taken place.



    WORKAROUND
    To workaround this problem either:

    Avoid the use of non-logged operations.

    -or-


    Ensure that any process performing non-logged operations complete and secure a complete database backup

Posting Permissions

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