Sql Server Tempdb Full. Temp is getting full, i tried to shrink each file with small chunks but no use. There are many activities can happen in tempdb.
Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup,or setting autogrowth on for existing files in the filegroup. If a rollback fails in tempdb because of limited space, sql server crashes. For a tempdb database, sql corruption would change the status of the database as suspect and this will interrupt sql server service from starting.
