On one of our MS SQL Server 2005 boxes, we have a small problem each morning when the Maintenance Plan runs. For just a few seconds, the server's C:-drive gets filled up, leaving less than 1GB free, where normally it has more than 7GB free. It is interfering with the replication program on the system, which halts when the free space dips too low but doesn't automagically start itself when its free again.
(To give you an idea of how fast it goes, here are this morning's times: At 05:08:43 Free disk space <1GB, then at 05:08:51 Free disk space >7GB. In less than 10 seconds 6gb of data was created and destroyed.)
The Maintenance Plan does the following: check databases, shrink databases, reorganize indexes, and cleanup its old log files.
Note that SQL Server is installed on the C:-drive, but all the databases and the tempdb have been moved to another larger drive. Is there some other temp directory or such that SQL Server might be using during these tasks that I need to re-point to a different drive?