fatal error 7105

hi guys,
does anyone know what would have caused this error happened:
[microsoft][ODBC sql server driver][sql server]warning:fatal error 7105
i have check with microsoft technet and it said:
Page %S_PGID, slot %d for text, ntext, or image node does not exist.
thanks.
best regards,
kharulli

Hi,

these datatypes are stored as pointers. It seems that your pointers are pointing to orphanded pages, so you can

1. Check the SQL Server log to see what happened.
2. Run DBCC CHECKDB to check the concistency of your database. (or run DBCC CHECKTABLE on single tables).

DBCC should find the error in your tables.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Moving to the "SQL Server Database Engine", which is closer related to the error you see.

|||

In %mssql%\log directory check the errorlogs and sql*.mdmp or sql*.txt files. Can you share these?

Any idea what was running on the server when you hit this?

Thanks