Full log files

Hi, I am new to SQL server and need some help with full
log files. The error I am getting is:
Full msdb log error 9002; and
Full tempdb log error 9002.
How do I fix it?
Col :-)Hi,
"This error occurs when the transaction log becomes full"
Execute the below command in Query analyzer and check the log file % usage:-
DBCC SQLPERF(LOGSPACE)
If it is not 100% then the cause for this error is that there is no room on
the disk for the transaction log file to autogrow.
Solution:
Either you have to shrink the log file belongs to TEMPDB (this must be the
guy who used the maximum hard disk space). Normally MSDB will not have
much transaction log growth.
There are 3 methods to shrink the tempdb,
1. ALTER DATABASE TEMPDB MODIFY FILE ...
2. DBCC SHRINKDB
3. DBCC SHRINKFILE
look into this link for details,
http://support.microsoft.com/defaul...b;en-us;Q307487
Thanks
Hari
MCDBA
"Col" <colin.james@.waca.com.au> wrote in message
news:293901c42827$c5159ca0$a001280a@.phx.gbl...
> Hi, I am new to SQL server and need some help with full
> log files. The error I am getting is:
> Full msdb log error 9002; and
> Full tempdb log error 9002.
> How do I fix it?
> Col :-)