The transaction log for database 'databasename' is full due to 'ACTIVE_TRANSACTION'.

hi there
ive accidentally imported thousands of blank products to my database.
Im trying to delete them via sql query express but it cannot be done as i get the error

The transaction log for database 'databasename' is full due to 'ACTIVE_TRANSACTION'.


is there anyway to get around this error?

thanks !

Is this a hosted database, or do you have access to maintain it?


See if this helps.

https://stackoverflow.com/questions/23820741/sql-server-log-is-full-due-to-active-transaction

hi there
thanks for reply. the database is on sharded windows hosting. io have tried all the suggestions on the link but all fail to run..