Pages

Wednesday, August 21, 2013

SQL SERVER – TempDB is Full. Move TempDB from one drive to another drive. | Journey to SQL Authority with Pinal Dave

If you come across following errors in log file, please follow the direction below. Source: MSSQLSERVER Event ID: 17052 Description: The LOG FILE FOR DATABASE 'tempdb' IS FULL. Back up the TRANSACTION LOG FOR the DATABASE TO free up SOME LOG SPACE Make sure that TempDB is set to autogrow and do not set a… Continue Reading...

Source: SQL SERVER – TempDB is Full. Move TempDB from one drive to another drive. | Journey to SQL Authority with Pinal Dave