How to clear log ?

Hi,
I am using SQL sever 2000,
My server said, the Log file for MSDB is full, what should I do to clear the
log history?
Thanks
MichaelFairly simple - back up & truncate the log.
You can do this either via the SQL Enterprise Manager or issuing the backup
log command, but before you rush off trying to do that, if you've got DBAs
you're probably best off approaching them as this is something they'd
normally look after.
Regards,
Greg Linwood
SQL Server MVP
"Michael" <vbvfvid@.yahoo.com.sg> wrote in message
news:%238DMrtbyDHA.3220@.tk2msftngp13.phx.gbl...
> Hi,
> I am using SQL sever 2000,
> My server said, the Log file for MSDB is full, what should I do to clear
the
> log history?
> Thanks
> Michael
>|||Is there any Transaction-SQL cmd can clear the logs?
I checked the database, it only sized 14MB, please tell me how to enlarge
the log file history or size? Is there any documents talking about this?
Thanks
Michael
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:Oa0xVzbyDHA.1908@.TK2MSFTNGP10.phx.gbl...
> Fairly simple - back up & truncate the log.
> You can do this either via the SQL Enterprise Manager or issuing the
backup
> log command, but before you rush off trying to do that, if you've got DBAs
> you're probably best off approaching them as this is something they'd
> normally look after.
> Regards,
> Greg Linwood
> SQL Server MVP
> "Michael" <vbvfvid@.yahoo.com.sg> wrote in message
> news:%238DMrtbyDHA.3220@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > I am using SQL sever 2000,
> > My server said, the Log file for MSDB is full, what should I do to clear
> the
> > log history?
> >
> > Thanks
> > Michael
> >
> >
>|||Hi Michael.
The term for "clearing" the transaction log is "truncating" the transaction
log. This will help you research the topic. Truncation of the transaction
log is usually performed whilst backing up the transaction log.
There is an article in the online SQL Server documentation on this here:
http://msdn.microsoft.com/library/en-us/architec/8_ar_da2_7vaf.asp
If you want to enlarge the transaction log via a t-sql command, you do this
via the ALTER DATABASE command, using it's MODIFY FILE argument. Eg:
ALTER DATABASE [database name]
MODIFY FILE (
NAME = [logical file name]
, SIZE = [target size]
)
Managing transaction logs is one of the fundamental aspects of managing SQL
Server databases (as with Oracle, DB2 etc). It's worth reading up more on
this as it will help build your knowledge of SQL Server significantly.
HTH
Regards,
Greg Linwood
SQL Server MVP
"Michael" <vbvfvid@.yahoo.com.sg> wrote in message
news:%23bo1u%23byDHA.3888@.tk2msftngp13.phx.gbl...
> Is there any Transaction-SQL cmd can clear the logs?
> I checked the database, it only sized 14MB, please tell me how to enlarge
> the log file history or size? Is there any documents talking about this?
> Thanks
> Michael
>
>
> "Greg Linwood" <g_linwoodQhotmail.com> wrote in message
> news:Oa0xVzbyDHA.1908@.TK2MSFTNGP10.phx.gbl...
> > Fairly simple - back up & truncate the log.
> >
> > You can do this either via the SQL Enterprise Manager or issuing the
> backup
> > log command, but before you rush off trying to do that, if you've got
DBAs
> > you're probably best off approaching them as this is something they'd
> > normally look after.
> >
> > Regards,
> > Greg Linwood
> > SQL Server MVP
> >
> > "Michael" <vbvfvid@.yahoo.com.sg> wrote in message
> > news:%238DMrtbyDHA.3220@.tk2msftngp13.phx.gbl...
> > > Hi,
> > >
> > > I am using SQL sever 2000,
> > > My server said, the Log file for MSDB is full, what should I do to
clear
> > the
> > > log history?
> > >
> > > Thanks
> > > Michael
> > >
> > >
> >
> >
>|||By default the MSDB database is in simple mode which would truncate the log
upon checkpoint and not allow for the log to grow too big. If the recov mode
for MSDB has been changed to full recov, you should implement regular backup
log commands or jobs to keep this in check, lookup backup log in BOL for
syntax or use a maint plan
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Michael" <vbvfvid@.yahoo.com.sg> wrote in message
news:%23bo1u%23byDHA.3888@.tk2msftngp13.phx.gbl...
> Is there any Transaction-SQL cmd can clear the logs?
> I checked the database, it only sized 14MB, please tell me how to enlarge
> the log file history or size? Is there any documents talking about this?
> Thanks
> Michael
>
>
> "Greg Linwood" <g_linwoodQhotmail.com> wrote in message
> news:Oa0xVzbyDHA.1908@.TK2MSFTNGP10.phx.gbl...
> > Fairly simple - back up & truncate the log.
> >
> > You can do this either via the SQL Enterprise Manager or issuing the
> backup
> > log command, but before you rush off trying to do that, if you've got
DBAs
> > you're probably best off approaching them as this is something they'd
> > normally look after.
> >
> > Regards,
> > Greg Linwood
> > SQL Server MVP
> >
> > "Michael" <vbvfvid@.yahoo.com.sg> wrote in message
> > news:%238DMrtbyDHA.3220@.tk2msftngp13.phx.gbl...
> > > Hi,
> > >
> > > I am using SQL sever 2000,
> > > My server said, the Log file for MSDB is full, what should I do to
clear
> > the
> > > log history?
> > >
> > > Thanks
> > > Michael
> > >
> > >
> >
> >
>|||backup log urdatabase with no_log
dbcc shrinkdatabase (urdatabase)
backup ur database afterwards.