SQL Server Performance Forum – Threads Archive
Error 7105 fatal error
Hello! We got the error 7105 reported once for a table. Page %S_PGID, slot %d for text, ntext, or image node does not exist. Someone here knows what we should do? The error have not showed up again in a couple of weeks. I am thinking of tabking a backup of all the data on the table. Drop the table, Create the table and create all the indexes again and then move the data from the backup. Would that help? The most important questions is still left. Why did this happen? How can we prevent this from happening again? Thanks!Check KBAs:
http://support.microsoft.com/kb/890755
http://support.microsoft.com/kb/304847
.. for a resolution. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
- You can run the query command again to see if that happens.
- If that is the condition, Run DBCC CHECKDB
- Update the SQL Server with latest server pack if problem is arising due to the SQL Server Engine
Hello! We got the error 7105 reported once for a table. Page %S_PGID, slot %d for text, ntext, or image node does not exist. Someone here knows what we should do? The error have not showed up again in a couple of weeks. I am thinking of tabking a backup of all the data on the table. Drop the table, Create the table and create all the indexes again and then move the data from the backup. Would that help? The most important questions is still left. Why did this happen? How can we prevent this from happening again? Thanks!
Welcome to the forums!.
Thanks for your help. Always check thread date. This one is 7 years old.
Nice try, mate.
Next time you advertise your tool without contributing anything useful to a 7 years old thread, I’ll flag it as spam.
]]>