My C: drive was getting low on disk space so I:
Changed the allotted space for tempdb to not grow any larger.
Reduced the memory space from 815 meg to 637 meg in sql server properties.
Rebooted the NT 4 server.
Now I am getting this error every minute. Also, in Enterprise Manager ,
database, shows: "no items".
Help!
[298] SQLServer Error: 9002, The log file for database 'tempdb' is full
Back
up the transacton log for the database to free up some log space. [SQLST
ATE
42000]
Thank you
Lancer 3Hi Lancer,
The first option I would try is to move the tempdb to another drive which
has sufficient space and allow DB to auto grow.
But if you want to keep it in the existing drive and want to limit the
growth of tempdb, it is a good idea to run the following on a scheduled
basis.... Do this during the non peak hours....
BACKUP LOG tempdb WITH TRUNCATE_ONLY
DBCC SHRINKDATABASE('tempdb',8)
Also go through this article
http://www.sql-server-performance.com/tempdb.asp
Thanks
Yogish
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment