Error 7105 fatal error | SQL Server Performance Forums

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.
Try to implement these steps in your database…
  • 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
But remember to take a backup of the data or the items stored in the database. Reference: http://www.sqldatabase-recovery.com
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.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |