I'm dealing with a MSSQL server whose transaction log has grown to 20GB where as the actual database file is only 7MB!
Its really difficult to administer because it keep eating up the harddisk space.
Is there any way to prevent this from happening?
Whats the cause? Only one user is connected to this server.
How can I clear the transaction log?