Problems with tempdb log.

Hi, I am trying to execute a process on a server that is running sql
server 2000 sp3. When i try to execute the process displays this error:
Error: 9002, Severity: 17, State: 6
The log file for database 'tempdb' is full. Back up the transaction log
for the database to free up some log space.
I check the tempdb log and is ok, i create a secundary file on another
disk and it still display the error. I drop and recreate the second file
and the error continues.
The process i executed by a cognos software.
The server has enought free space.
Do you know what could be the reason of this error.
Thanks a lot for your help.
*** Sent via Developersdex http://www.developersdex.com ***Can you check for open transactions?
dbcc opentran
go
AMB
"MariaGuzman" wrote:
> Hi, I am trying to execute a process on a server that is running sql
> server 2000 sp3. When i try to execute the process displays this error:
> Error: 9002, Severity: 17, State: 6
> The log file for database 'tempdb' is full. Back up the transaction log
> for the database to free up some log space.
> I check the tempdb log and is ok, i create a secundary file on another
> disk and it still display the error. I drop and recreate the second file
> and the error continues.
> The process i executed by a cognos software.
> The server has enought free space.
> Do you know what could be the reason of this error.
> Thanks a lot for your help.
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
>|||Better to read this.
Why is tempdb full, and how can I prevent this from happening?
http://www.aspfaq.com/show.asp?id=2446
AMB
P.S. Thanks god I do not have to pay to Aaron every time I post a link from
his oustanding web site.
"Alejandro Mesa" wrote:
> Can you check for open transactions?
> dbcc opentran
> go
>
> AMB
> "MariaGuzman" wrote:
> > Hi, I am trying to execute a process on a server that is running sql
> > server 2000 sp3. When i try to execute the process displays this error:
> >
> > Error: 9002, Severity: 17, State: 6
> > The log file for database 'tempdb' is full. Back up the transaction log
> > for the database to free up some log space.
> >
> > I check the tempdb log and is ok, i create a secundary file on another
> > disk and it still display the error. I drop and recreate the second file
> > and the error continues.
> >
> > The process i executed by a cognos software.
> >
> > The server has enought free space.
> >
> > Do you know what could be the reason of this error.
> >
> > Thanks a lot for your help.
> >
> >
> >
> >
> >
> >
> > *** Sent via Developersdex http://www.developersdex.com ***
> >