Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Flushing remote SQL server log file?

Status
Not open for further replies.

BeanDog

Programmer
Jul 15, 2000
60
US
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 );
benbeandogdilts@cs.com
Long-time BASIC game programmer, Internet programmer and C++/DirectX of late.
 
Hi there
start a ticket asking them to truncate ur sql log file
or
go to ur sql server's Enterprise Manager
then register ur interland sql server as a new sql server registeration
and then after registeration connect to it
the you can list all the databases that you have right to access and then select and
truncate the log file

Regards

Unicorn11
abhishek@tripmedia.com

[red]Luck is not chance, it's toil; fortune's expensive
smile is earned.[red]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top