Default filegroup is full (TempDB) (DATA COMPARE)

beachldy

I cannot run Data Compare without the error stating that the TempDB default filegroup is full. I'm not DATA COMPARING tempdb at all, but another SQL database. What is causing this error?

Brian Donahue

Hello,

SQL Data Compare isn't doing anything in tempdb per se, SQL Server uses tempdb to hold data that is being collated as the result of a JOIN operation. I'd imagine that SQL Data Compare uses joins in some cases.

What's disturbing is that you are getting this error, and by default, the tempdb database grows automatically. So either someone has gone in and fixed the size (I think tempdb uses whatever database properties are set on the MODEL database) or you are actually running out of free disk space so tempdb cannot expand.