SQL Problem. The log file for database...

[jai80]

Hi all,

Would be of great help if anybody can tell me how to solve this problem.

"Microsoft OLE DB Provider for SQL Server error '80040e14'

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

while searching for the solution & cause to this problem, i happened to come across that, one of the possible solutions could be: setting the recovery model of the database to "Simple" can sort out a lot of problems with transaction logs.

I want to know more about transaction log, data backups and solution to my problem. Thanks in advance.

Have a great day!
jai

[navamnk]

take a full backup and truncate the log

[jai80]

take a full backup and truncate the log

thanks buddy...

cheers,
jai

[ttcdr]

How do I truncate the log?

Thanks a lot.