while i delete a table using a SQL command

delete from table1
where inv_date between ? and ?

the error message appear show that the transaction log full,
i try to backup the database and shrink the database also cannot resolve a problem.
my harddisk space have a lot of space.

i had tried to create another database and transfer the table1 record into the new database table2
but during import the data, the transaction log also full for the new database,

any problem on my SQL server?


urgent!


Thanks and Regards

Try "backup log <log_name> with truncate_only" to reduce the log size. This reduces the log size by truncating it. Also you can change the logging type by right-clicking the database and select properties, click the options tab, and in the recovery section, change the drop-down box to simple. This should help your log not grow so fast. The tradeoff is that it doesn't log as much information as you normally would want it to log.

Hope this helps,

Brian