cannot connect to the database in sql server due to insufficient space for tempdb

by Chandra Shekar   Last Updated December 07, 2017 10:06 AM

My server is configured with alwayson. due to some unknown reason my tempdb in secondary server has occupied the complete disc space in the server which is about 56Gb. inorder to shrink the tempdb I tried to connect to the tempdb and I found that I am unable to connect any of the db's in it. I am getting the error as "could not allocate space for object tempdb because the primary filegroup is full". All I could do is restart the server,but since it is a production server I couldnt decide by myself.

Related Questions

Secondary Tempdb filling up on AG Setup

Updated April 12, 2018 14:06 PM

Multiple Location AlwaysOn and Azure SQL Server

Updated April 15, 2019 16:06 PM