MS SQL Server - Full tempdb log

Author

Full tempdb log

Silmar

2005-05-31, 9:23 am

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

Hari Prasad

2005-05-31, 8:23 pm

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
>

Sponsored Links