Home Forums SQL Server 7,2000 Administration Full tempdb Log RE: Full tempdb Log
e4d4
SSCertifiable
Points: 5777
More actions
January 15, 2013 at 2:15 pm
#1577536
Yes, if the DB must be online your only option is to increase size of the temdb. Then check what consume space eg:
http://thesqldude.com/2012/05/15/monitoring-tempdb-space-usage-and-scripts-for-finding-queries-which-are-using-excessive-tempdb-space/
maybe the tempdb size should be larger.