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 ..Do you know if this happened during a restore ?|||There looks to be a Technet article on this problem:
BUG: Error Message 823 or Retail Assert Encountered During Restore of SQL Server Log Backup (Q281809) (http://support.microsoft.com/default.aspx?scid=kb;EN-US;q281809)|||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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment