as subject!
i'm using sql server 2000.Mulli
BACKUP LOG databaseane WITH TRUNCATE_ONLY
For moredetails please refer to the BOL.
"Mullin Yu" <mullin_yu@.ctil.com> wrote in message
news:u#ZeB0yBEHA.3748@.TK2MSFTNGP11.phx.gbl...
> as subject!
> i'm using sql server 2000.
>|||hi mullin,
You cannot delete the "sql server logs" from Enterprise manager.These files
are stored under
folder
C:\Program Files\Microsoft SQL Server\log\
-- OR (for named instance)
C:\Program Files\Microsoft SQL Server\MSSQL$<instance_name>\log\
delete them from this location, and right click in the enterprise manager on
"sql server logs"
and click on refresh.
it wont show the logs that have been deleted.
Note: you can not delete current errorlog file.
Also one more point to be noted that, if your current errolog has grown big,
you can recyle it
forcefully by running sp_cycle_errorlog from query analyzer
Vishal Parkar
vgparkar@.yahoo.co.in
No comments:
Post a Comment