i have a database of 10 mb sql 2000 and a log space of 2 mb (c:program filesmsssql...) for the same in which auto grow option is disabled for space constraints. The asp file while adding records to db gave a transaction log full error . I backed up the log file on d:logs... . I think sql 2000 truncates the logs when backed up. But this didnt happen the asp file was still giviing errors. What culd be wrong ? Any workarounds .<BR><BR>please help<BR>brij <BR>