Re: db library error ?

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 02/08/05 

Date: Tue, 8 Feb 2005 17:58:56 +0100

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
>
>

Relevant Pages

  • Re: Can I move tempdb?
    ... Tempdb file name changes take affect after SQL Server is restarted and are ... reference posted by details procedures for moving other database files. ... Model isn't used to determine database file locations. ...
    (microsoft.public.sqlserver.server)
  • Re: Checkpointing Not Happening in Simple Recovery Model
    ... You cannot set the recovery model in tempdb. ... Columnist, SQL Server Professional ... We would then have to issue an alter database ...
    (microsoft.public.sqlserver.server)
  • Re: How is VFP comparing to C#/VB in terms of performance to SQL Serve
    ... You can't write it to your database because it's down. ... Isn't that when you throw up a box with some kind of cryptic error message and offer to report it to Microsoft before you app crashes taking the data with it? ... It is possible to write slow applications in VFP and it is equally possible to write slow applications in VB/C#. ... If the SQL server is down, where do you log the error message? ...
    (microsoft.public.fox.helpwanted)
  • "The parameter is incorrect" error, adding table in Database Explorer
    ... Whenever I attempt to "Add New Table" to a SQL Server 2005 Express database ... get a pop up error message stating "The parameter is incorrect". ...
    (microsoft.public.vsnet.general)
  • Re: DNS Server Error when Hitting Database?
    ... What is the specific error message you are seeing? ... The application accesses a SQL Server database ... The SQL Server account in question is an owner for the ...
    (microsoft.public.dotnet.framework.aspnet)
Quantcast