msde log file full

Getting error "msde log file is full, back up the transaction file for the d
atabase." I do not know how to clear out the log file for msde? Any help i
s greatly appreciated.
Thank you very muchIf you need to keep your log backup sequence intact, you can
use something similar:
backup log msde
to disk = 'D:\PathToYourBackups\YourDB_Log.bak'
If you do not want to keep the log backup and can afford to
have the log sequence invalidated, you can use something
along the lines of:
backup log msde with truncate_only
For more information, refer to Backup in books online.
Additionally, if you aren't using the logs as part of your
recovery plan for the database, you can set it to simple
recovery.
-Sue
On Tue, 20 Apr 2004 17:36:04 -0700, Marion
<anonymous@.discussions.microsoft.com> wrote:

>Getting error "msde log file is full, back up the transaction file for the
database." I do not know how to clear out the log file for msde? Any help
is greatly appreciated.
>Thank you very much|||Hi,
First check the recovery model for the database "MSDE". If it is FULL, you
need to backup the transaction log in frequent intervals. Otherwise
every time you will get this sort of error, even if you clear the log once.
I feel that you are using MSDE, You have to OSQL command line utility
OSQL -Usa -Ppassword -S Servername -Q"sp_helpdb MSDE"
If the recover model is FULL , then you have to Backup the transaction log
and shrink the transaction log file
From command prompt execute
OSQL -Usa -Ppassword -S Servername (Press enter, this will go to a prompt)
backup log MSDE to disk='d:\backup\dbname.trn'
go
dbcc shrinkfile('logical_log_file',truncateon
ly)
go
If the recovery model is SIMPLE then you do not want to schedule a
transaction log backup.
From command prompt execute
OSQL -Usa -Ppassword -S Servername (Press enter, this will go to a prompt)
backup log MSDE with truncate_only
go
dbcc shrinkfile('logical_log_file',truncateon
ly)
go
Note:
Logical Log file name can identified by executing:
OSQL -Usa -Ppassword -S Servername (Press enter, this will go to a prompt)
use MSDE
go
sp_helpfile
(The name column contains the logical file name)
Thanks
Hari
MCDBA
"Marion" <anonymous@.discussions.microsoft.com> wrote in message
news:7C1DFCCA-9BF5-478E-B7AB-21F027A638FE@.microsoft.com...
> Getting error "msde log file is full, back up the transaction file for the
database." I do not know how to clear out the log file for msde? Any help
is greatly appreciated.
> Thank you very much