Sunday, November 28, 2010

Resolving tempdb log file is full in SQL2000

In SQL 2000, if you have the error,

"The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space."

To resolve this you need to truncate the log file by using

dump log tempdb with truncate_only

the normal backup log command won't work in this case

1 comment:

farleydaignault said...

Wynn casino new poker room - JSHub
As 영주 출장마사지 noted 광주 출장안마 in a press release, Wynn 포천 출장샵 Las Vegas will be expanding Wynn 청주 출장샵 Poker 아산 출장마사지 Room to other poker games,” the press release states.