Full tempdb log

Hi!
Does anybody know how SQL server behaves when below event is logged? Will it
stop or only part of its functionality will become unavailable?
Error: 9002, Severity: 17, State: 6 The log file for database 'tempdb' is
full. Back up the transaction log for the database to free up some log
space.
Regards
Silmar
Hi,
SQL Server service will not stop if Tempdb log is full. But all the
operations which require a tempdb (Sort, Group, joins) will fail
if tempdb log is full.
See the size of LDF file for Tempdb. If the size is too small then try to
increase the size or move it to a hard drive which have more space.
Thanks
Hari
SQL Server MVP
"Silmar" <silmar.NO_SPAM@.talex.pl> wrote in message
news:uRDob%23dZFHA.3852@.TK2MSFTNGP10.phx.gbl...
> Hi!
> Does anybody know how SQL server behaves when below event is logged? Will
> it stop or only part of its functionality will become unavailable?
> Error: 9002, Severity: 17, State: 6 The log file for database 'tempdb' is
> full. Back up the transaction log for the database to free up some log
> space.
> Regards
> Silmar
>

Full tempdb log

Hi!
Does anybody know how SQL server behaves when below event is logged? Will it
stop or only part of its functionality will become unavailable?
Error: 9002, Severity: 17, State: 6 The log file for database 'tempdb' is
full. Back up the transaction log for the database to free up some log
space.
Regards
SilmarHi,
SQL Server service will not stop if Tempdb log is full. But all the
operations which require a tempdb (Sort, Group, joins) will fail
if tempdb log is full.
See the size of LDF file for Tempdb. If the size is too small then try to
increase the size or move it to a hard drive which have more space.
Thanks
Hari
SQL Server MVP
"Silmar" <silmar.NO_SPAM@.talex.pl> wrote in message
news:uRDob%23dZFHA.3852@.TK2MSFTNGP10.phx.gbl...
> Hi!
> Does anybody know how SQL server behaves when below event is logged? Will
> it stop or only part of its functionality will become unavailable?
> Error: 9002, Severity: 17, State: 6 The log file for database 'tempdb' is
> full. Back up the transaction log for the database to free up some log
> space.
> Regards
> Silmar
>

Full tempdb log

Hi!
Does anybody know how SQL server behaves when below event is logged? Will it
stop or only part of its functionality will become unavailable?
Error: 9002, Severity: 17, State: 6 The log file for database 'tempdb' is
full. Back up the transaction log for the database to free up some log
space.
Regards
SilmarHi,
SQL Server service will not stop if Tempdb log is full. But all the
operations which require a tempdb (Sort, Group, joins) will fail
if tempdb log is full.
See the size of LDF file for Tempdb. If the size is too small then try to
increase the size or move it to a hard drive which have more space.
Thanks
Hari
SQL Server MVP
"Silmar" <silmar.NO_SPAM@.talex.pl> wrote in message
news:uRDob%23dZFHA.3852@.TK2MSFTNGP10.phx.gbl...
> Hi!
> Does anybody know how SQL server behaves when below event is logged? Will
> it stop or only part of its functionality will become unavailable?
> Error: 9002, Severity: 17, State: 6 The log file for database 'tempdb' is
> full. Back up the transaction log for the database to free up some log
> space.
> Regards
> Silmar
>

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 :-)