磁盘上的可用空间不会被识别为数据库中的未分配空间 [英] Free space on the disk is not recognized as unallocated spaces in the database

问题描述

我有一个空间不足的数据库。我删除了数百万条旧的历史记录，并在其中一张最大的表中删除了一些高度分散的索引并重新创建它们。通过这样做，我能够在磁盘上打开大约75 Gig。但是
，当我查看数据库属性文件时，我只看到241 Meg作为未分配的空间而我的作业都无法运行，因为我收到的磁盘空间不足错误消息。要将可用磁盘空间分配给数据库，我需要做什么？请
帮助！ 

谢谢，

解决方案

1）

USE DB;
$
GO

DBCC SHRINKFILE（LogicalDataFileName，target_sizeInMB）;

GO

2）你没有禁用数据库的自动增长能力？

执行sp_spaceused

此查询的输出将告诉您未分配的空间或数据库文件中的可用空间。当这个填满时，您的数据库将根据各种设置和环境增长或停止。

你的是什么？输出？

I have a database that was running out of space. I deleted millions of old historical records and dropped couple of highly fragmented indexes in one of the largest table and recreated them. I was able to open up about 75 Gig on the disk by doing so. But , when I look at the database property files , I only see 241 Meg as unallocated spaces and none of my jobs are able to run, because I receive insufficient disk space error message. What do I need to do to allocated the free disk space to the database ? Please help! 

Thanks, 

解决方案

1)

USE DB;
GO
DBCC SHRINKFILE (LogicalDataFileName, target_sizeInMB );
GO

2)haven't you disabled the database's ability to autogrow?

EXECUTE sp_spaceused
The output of this query will tell you the unallocated space, or free space available in your DB file. When this fills up, your DB will either grow or will stop, based on various settings and circumstances.

What is your  output?

这篇关于磁盘上的可用空间不会被识别为数据库中的未分配空间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！