flushing set-length remote log file?

[BeanDog]

My SQL Server database is set up remote on Interland's servers, and recently all my applications ground to a halt as I get an error message saying that the log file is full. How can I remedy this problem? I have already tried to contact Interland, but in a week haven't gotten any replies yet.

I'm using Visual Interdev 6 for all my programming.



~BenDilts( void );

~BenDilts( void );
benbeandogdilts@cs.com

http://www.geocities.com/benbeandogdilts

Long-time BASIC game programmer, Internet programmer and C++/DirectX of late.

 

[cdukes]

You need to truncate your SQL Server transaction Log. This should be done automatically when the database option 'Truncate transaction log on checkpoint' is selected and should also be done when you backup the database. See books on line 'Truncating the transaction log'

If this is not being done by your service provider then I suggest you talk to them.

You can also do this by SQL commands if you have permission at a command prompt:

BACKUP LOG WITH TRUNCATE_ONLY

You must be aware that this command will remove all transactions in the transaction log that have been comitted.

Please read the books on line article as this should be done automatically.

Hope this helps,

Chris Dukes