Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 problem with logfile

Author  Topic 

rammohan
Posting Yak Master

212 Posts

Posted - 2009-11-25 : 01:22:56
i have a database xyz,in that i had table called abc.

i trying this query :

truncate table abc.

but i am getting following error:

The log file for database 'xyz' is full. Back up the transaction log for the database to free up some log space.

how to solve this?

One can never consent to creep,when one feels an impulse to soar
RAMMOHAN

rammohan
Posting Yak Master

212 Posts

Posted - 2009-11-25 : 03:43:43
please help me asap

One can never consent to creep,when one feels an impulse to soar
RAMMOHAN

Go to Top of Page
   

- Advertisement -