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
Sunday, November 28, 2010
Subscribe to:
Posts (Atom)