Fast Growth in Database file : LUSENET : SQL Server Database Administration : One Thread

Hi Eric, Ur explanation is really very helpful for me. at present i got a problem like the server's database size is growing fastly. it was 900mb previously but now it is around 1.8 G.B.what might be the problem? they have around 40 temporary tables. might be because of that! if it so shall i delete those temporary table records. The same database in oracle occupies only 300 MB SPACE

Regards, Raja V

-- Anonymous, May 08, 2003



Yes, it sounds like deleting the temporary tables would be a good approach.

Good Luck,


-- Anonymous, May 11, 2003

Moderation questions? read the FAQ