Shulou(Shulou.com)05/31 Report--

This article shows you why it is impossible to allocate space for the objects in the database tempdb. The content is concise and easy to understand, and it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Error description

Message 1105, level 17, status 2, line 1

Unable to allocate space for 'objects in tempdb'' dbo.SORT temporary run storage: 140737503494144' because the 'PRIMARY' filegroup is full. Delete unwanted files, delete objects in the filegroup, add other files to the filegroup, or enable automatic growth for existing files in the filegroup to increase available disk space.

Message 9002, level 17, status 4, line 1

The transaction log for database 'tempdb' is full. To find out why the space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases.

Solution method

[sql] view plaincopyprint?

View the current size of tempdb

Exec sp_helpdb tempdb

Shrink the tempdb

Use tempdb

Go

Dbcc shrinkfile (tempdev, 1024)

Use tempdb

Go

Dbcc shrinkfile (templog, 512)

Try to set the file initial value of tempdb:

Data file: 10G

Log file: 10G

10% of automatic growth is set to 10m

The above is why you can't allocate space for objects in the database tempdb. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.