Default filegroup is full (TempDB) (DATA COMPARE)

beachldybeachldy Posts: 17
edited September 19, 2007 12:20PM in SQL Data Compare Previous Versions
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?

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.
Sign In or Register to comment.