[Transfer] SQL Server Tips: text.ntext or image node page (1: XX), 4 slot solution that does not exist

2011-08-16  来源:本站原创  分类:Database  人气:214 

SQL SERVER query the database will appear similar to the following tips:

Microsoft OLE DB Provider for SQL Server (0x80004005)
[Microsoft] [ODBC SQL Server Driver] [SQL Server] text, ntext, or image node page (1:220), slot 14 does not exist.
[Microsoft] [ODBC SQL Server Driver] [SQL Server] Communication link failure
[Microsoft] [ODBC SQL Server Driver] [SQL Server] Warning: Fatal error 7105 occurred on 10 7 2008 10:15 AM

This data sheet describes a problem, and need to be repaired, the repair is simple in execution the following sql query analyzer in a program on it, but remember not to select the database you want to repair because the operation is then carried out under single-user.

USE MASTER
GO
sp_dboption 'database name', 'single user', 'true'
Go
DBCC CHECKDB ('database name', REPAIR_ALLOW_DATA_LOSS)
Go
USE database name
go
exec sp_msforeachtable 'DBCC CHECKTABLE ("table", REPAIR_ALLOW_DATA_LOSS)'
exec sp_msforeachtable 'DBCC DBREINDEX ("Table Name")'
go
sp_dboption 'database name', 'single user', 'false'
Go

Executed on OK.

Originally posted: http://blog.sina.com.cn/s/blog_721767bb0100nwu9.html

相关文章