hola gente!
Al tratar de regenerar un indice fulltext sobre un atabla de mas de 20
millones de registros
luego de varias horas mas de 6, llega a procesar de 7 a 12 millones de
registros y luego queda en estado de shutdown.
estos son algunos de los mensajes de error
The transaction cannot be appended to the project <SQLServer SQL0000800005>
queue. File: F:\Program
Files\Microsoft SQL
Server\MSSQL\FTDATA\SQL0000800005\SQL0000800005.Ntfy1.gthr. Error:
80070021 - The process cannot access the file because another process has
locked a portion of the file. .
Eventid:3011
The transaction cannot be updated in the project <SQLServer SQL0000800005>
queue. File: F:\Program Files\Microsoft SQL
Server\MSSQL\FTDATA\SQL0000800005\SQL0000800005.Crwl0.gthr. Error:
8007054e - Unable to complete the requested operation because of either a
catastrophic media failure or a data structure corruption on the disk. .
Eventid:3015
The transaction file on project <F:\Program Files\Microsoft SQL
Server\MSSQL\FTDATA\SQL0000800005\SQL0000800005.Crwl0.gthr> cannot be read.
Error: Unable to complete the requested operation because of either a
catastrophic media failure or a data structure corruption on the disk. - %4.
Eventid: 3025
The critical error 9 occurred in project <SQLServer SQL0000800005>. Error:
8007054e - Unable to complete the requested operation because of either a
catastrophic media failure or a data structure corruption on the disk. . The
project has been shut down. The system is probably low on the resources.
Free up resources and restart the service.
el espacio en disco es de espacio en disco de 30,8 GB.
es un server con 4 GB de RAM
alguna idea?
saludos a todos
Mauro
Leer las respuestas