SQL Server Performance Forum – Threads Archive
Error :logfile exceeds maxsize
Hi I work on a remote server.I perform Bulk Inserts and frequent Updates,I facefollowing problem very fortnight…. 17066 :
SQL Server Assertion: File: <R:sql
tdbmsstorengdrsinclude
ecord.inl>, line=1447
Failed Assertion = ‘m_SizeRec > 0 && m_SizeRec <= MAXDATAROW’. I am looking for a permanent solution. Please help
raj
Hi,<br />Please check the bulk insertion option is set or not.[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br /><br />hsGoswami
Hi,
another question arise in my mind that have you restrict file grow ? if it so would might create problem for you. hsGoswami
[email protected]
.. and also ensure the account used has required privileges on local and remote server in order to perform the operation. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Hi, I have the exact same error on our SQL Server, does anyone know how to fix this. I’m really quite desperate for a fix. Tracy
Check the record length. Lokks like it has gone above the 8060 bytes limit Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>