Showing posts with label subjecti. Show all posts
Showing posts with label subjecti. Show all posts

Wednesday, March 7, 2012

how to delete SQL Server Logs entries under Management

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