Discussion :

[htiteuf]

Bonjour,

Nous avons testé le Trace Flag 610. Or quand celui-ci et uniquement celui-ci est activé nous avons comme erreur (SSIS job):

Error Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB
error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native
Client 10.0" Hresult: 0x80004005 Description: "During undoing of a
logged operation in database 'XXXX', an error occurred at log record
ID (82254385:1023360:1). Typically, the specific failure is logged
previously as an error in the Windows Event Log service. Restore the
database or file from a backup, or repair the database.".
An OLE DB record is available. Source: "Microsoft SQL Server Native
Client 10.0" Hresult: 0x80004005 Description: "The log for database
'XXXX' is not available. Check the event log for related error
messages. Resolve any errors and restart the database.".
An OLE DB record is available. Source: "Microsoft SQL Server Native
Client 10.0" Hresult: 0x80004005 Description: "During undoing of a
logged operation in database 'XXXX', an error occurred at log record
ID (82254385:3868989:319). Typically, the specific failure is logged
previously as an error in the Windows Event Log service. Restore the
database or file from a backup, or repair the database.".
An OLE DB record is available. Source: "Microsoft SQL Server Native
Client 10.0" Hresult: 0x80004005 Description: "The log for database
'XXXX' is not available. Check the event log for related error
messages. Resolve any errors and restart the database.".
An OLE DB record is available. Source: "Microsoft SQL Server Native
Client 10.0" Hresult: 0x80004005 Description: "During undoing of a
logged operation in database 'XXXX', an error occurred at log record
ID (82254385:1024028:195). Typically, the specific failure is logged
previously as an error in the Windows Event Log service. Restore the
database or file from a backup, or repair the database.".
An OLE DB record is available. Source: "Microsoft SQL Server Native
Client 10.0" Hresult: 0x80004005 Description: "An inconsistency was
detected during an internal operation. Please contact technical
support.".
An OLE DB record is available. Source: "Microsoft SQL Server Native
Client 10.0" Hresult: 0x80004005 Description: "Time-out occurred
while waiting for buffer latch type 4 for page (9:1538572), database
ID 5.".

Et la base est notée Suspect

Nous pouvons reproduire cela sur les bases de Production et Test avec des hardware différents.

Pourrait-il s'agir d'un bug Microsoft? Ou avez-vous des pistes?

Merci

[SQLpro]

Quelle version de MS SQL Server 2000, 2005, 2008, 20008 R2, 2012 ?
Quelle edition : Express, standard, enterprise ,??

Enfin, pourquoi avoir mis en place ce Trace Flag 610 ?
Généralement l'utilisation de ce genre de trace est fortement déconseillée !!!!

A +

[dbaffaleuf]

thread également posté sur le forum MS: http://social.msdn.microsoft.com/For...7-c4ad29181adf