无法为数据库中的对象分配空间 [英] could not allocate space for object in database

问题描述

我们如何解决无法为数据库中的对象分配空间因为'主'文件组已满

请帮帮我

解决方案

< blockquote>阅读以下链接：

http://social.msdn.microsoft.com/Forums/en/sqldataaccess/thread/00976ed7-e5d2-4001-a527-bb3fd356ee62 [ ^ ]



http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=97084 [ ^ ]

 sp_helpdb ptitsolutions 

- 检查数据库和日志文件大小信息

  ALTER   DATABASE  ptitsolutions  SET 恢复简单

根据您自己的需求，如果不想制作日志文件

  DBCC  SHRINKFILE（DBNAME_log）
 
  ALTER   DATABASE  DBNAME 
 MODIFY  FILE （NAME = DBNAME_data，MAXSIZE = 500MB）;   -    set size  
 MODIFY  FILE （NAME = DBNAME_data，SIZE = 500MB）;   -    set size  
 MODIFY  FILE （NAME = DBNAME_log，MAXSIZE = 500MB）;   -    set size  

how we can solve the could not allocate space for object in database because the 'primary' filegroup is full
please help me

解决方案

Read the following links :
http://social.msdn.microsoft.com/Forums/en/sqldataaccess/thread/00976ed7-e5d2-4001-a527-bb3fd356ee62[^]

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=97084[^]

sp_helpdb ptitsolutions

--to check database and log file size information

ALTER DATABASE ptitsolutions  SET RECOVERY SIMPLE

As per your own demand if dont wants to make log file

DBCC SHRINKFILE(DBNAME_log)

ALTER DATABASE DBNAME
MODIFY FILE(NAME = DBNAME_data, MAXSIZE = 500MB);--set size
MODIFY FILE(NAME = DBNAME_data, SIZE = 500MB);--set size
MODIFY FILE(NAME = DBNAME_log, MAXSIZE = 500MB);--set size

这篇关于无法为数据库中的对象分配空间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！