Article ID: 199364
Article Last Modified on 10/27/2006
APPLIES TO
- Microsoft Systems Management Server 1.2 Standard Edition
This article was previously published under Q199364
SYMPTOMS
If the temporary database (tempdb) becomes full, you may be unable to perform queries or any activities in SQL Server. You may also get an SQL Server error 1105:
WORKAROUND
To work around this problem, you should move tempdb onto a different device so that it is no longer on the master database device and then expand its size. To do this, perform the following steps:
- Stop and restart SQL Server. Doing this resets tempdb, which should at least temporarily resolve the problem.
- See the following article in the Microsoft Knowledge Base for instructions on how to move tempdb to a different device:
Note that the instructions in this article also include the steps for expanding the size of tempdb after moving it to a different device.
187824 INF: How to Move Tempdb to a Different Device"
- Stop and restart SQL Server.
MORE INFORMATION
In general, the size of the temporary database (tempdb) should be approximately 20 percent of the size of your largest SQL Server database.
For additional information about why the transaction log may be filling up, please see the following article in the Microsoft Knowledge Base:
110139 INF: Causes of SQL Transaction Log Filling Up
Additional query words: prodsms err message msg smssql
Keywords: kbdatabase kbprb KB199364
