Results 1 to 4 of 4

Thread: error 7105

  1. 07-15-2008, 01:24 PM #1
    DLu
    DLu is offline Registered User
    Join Date
    Mar 2003
    Posts
    383

    error 7105

    Hi:

    get error in SQL log:

    spid73: Page (1:458541), slot 18 for text, ntext, or image node does not exist..

    Error: 7105, Severity: 22, State: 6

    Is there a way to know what is Page (1:458541) related?
    any dbcc commands related to?

    thanks
    David
    Reply With Quote Reply With Quote
  2. 07-16-2008, 09:29 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    What's the query spid 73 ran? Uses nolock hint? If so, it's caused by dirty read and you can ignore it.
    Reply With Quote Reply With Quote
  3. 07-16-2008, 05:05 PM #3
    DLu
    DLu is offline Registered User
    Join Date
    Mar 2003
    Posts
    383
    Hi Rmiao:

    Yes, I believe it was using with (nolock).

    Thu, the error might be occurred in archiving data time.

    Does the "Page (1:458541)" mean that it was related to a large table at its 458541th page?

    thanks
    -D
    Reply With Quote Reply With Quote
  4. 07-17-2008, 08:20 AM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    It's page id number instead.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules