Friday, February 17, 2012

db library error ?

Hi,
the application that I run has crashed this morning when
the following error message apeared :
SQL Server message 10054:
Possible network Error: Write to SQL Server failed.
General network error.Chek your documentation.
Debuging info:DBsqlexec, Begin Transaction - execute DBproc
optional info : Begin transaction.
At the same time the following appeared in SQl Server
Error log :
The log file for database 'tempdb' is full. Back up the
transaction log for the database to free up some log
space..
Error: 9002, Severity: 17, State: 6
Does anybody know what caused it?
I was reading something about error handling db library
error messages ...does this error handling should be
incorporated in the application ?
Why am I seeing "The log file for database 'tempdb' is
full" . As far as I know temp db should never be full and
as long as I have space for it's expansion there should be
no problem.
Thanks very much,
Natasa
Sometimes autogrow doesn't grow fast enough for the workers that need the space. Try pre-allocating
space for the tempdb database files...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Natasha" <anonymous@.discussions.microsoft.com> wrote in message
news:084e01c50df8$810d2520$a601280a@.phx.gbl...
> Hi,
> the application that I run has crashed this morning when
> the following error message apeared :
> SQL Server message 10054:
> Possible network Error: Write to SQL Server failed.
> General network error.Chek your documentation.
> Debuging info:DBsqlexec, Begin Transaction - execute DBproc
> optional info : Begin transaction.
> At the same time the following appeared in SQl Server
> Error log :
> The log file for database 'tempdb' is full. Back up the
> transaction log for the database to free up some log
> space..
> Error: 9002, Severity: 17, State: 6
> Does anybody know what caused it?
> I was reading something about error handling db library
> error messages ...does this error handling should be
> incorporated in the application ?
> Why am I seeing "The log file for database 'tempdb' is
> full" . As far as I know temp db should never be full and
> as long as I have space for it's expansion there should be
> no problem.
> Thanks very much,
> Natasa
>

No comments:

Post a Comment