In SQL server 6.5, I've got the message (the application log file is full)
after restarting the server and before login. this makes the working database
useless and marked inaccessible. Please I need and advice how can I solve the
problem.

KHATER,

It has been a while since I worked with 6.5, but I believe that once you get
into the server, from a query window in master, issue

DUMP TRANSACTION MyDB WITH NO_LOG

This _should_ always work since it throws the log away without even
checkpointing the database. So, if this works for you immediately after you
should do a DUMP DATABASE.

You mentioned that the database was inaccessible, but not that it was marked
SUSPECT, so go ahead and try this.


RLF


[quoted text, click to view]

KHATER,

I misread your comment to be a transaction log. For the Windows application
log, do the following:

Log into your server as the Windows Administrator.
From Start / Settings / Control Panel, select Administrative Tools / Event
Viewer.
Select: Clear All Events
Then change the properties to: Overwrite Events As Needed.

RLF

[quoted text, click to view]