无法为数据库"WFInstanceManagementDB"中的对象"dbo.Instances"."PK_Instances"分配空间，因为"PRIMARY"文件组已满 [英] Could not allocate space for object 'dbo.Instances'.'PK_Instances' in database 'WFInstanceManagementDB' because the 'PRIMARY' filegroup is full
问题描述
触发SPD 2013 WORKFLOWS(在Workflow Manager中配置)时，我在数据库服务器上的事件查看器中收到以下错误:我的意思是我的工作流未触发:
Am getting the below error in my eventviewer on my db server, while triggering SPD 2013 WORKFLOWS,which been configured with Workflow Manager: i mean my workflows are not triggering:
"1尝试失败后，SQL命令失败，错误为'1105'.异常:System.Data.SqlClient.SqlException(0x80131904):无法为数据库WFInstanceManagementDB中的对象dbo.Instances.PK_Instances分配空间，因为"PRIMARY"文件组已满. 通过删除不需要的文件，删除文件组中的对象，向文件组添加其他文件或为文件组中的现有文件设置自动增长来创建磁盘空间."
"Failed SQL command after 1 tries with error '1105'. Exception: System.Data.SqlClient.SqlException (0x80131904): Could not allocate space for object 'dbo.Instances'.'PK_Instances' in database 'WFInstanceManagementDB' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup."
如何解决这个问题?我已在其他服务器和E:\驱动器上安装了sql server 2012 r2，但空间为
how to resolve this issue? i have installed my sql server 2012 r2 on a different server and on E:\ drive but the space is 0
bytes.
推荐答案
由于此问题与SQL Server数据存储有关，我建议您清除未使用的文件从磁盘，然后缩小数据或日志文件.
https://technet.microsoft.com/en-us/library/ms190757%28v=sql.110%29.aspx?f=255&MSPPError=-2147217396
或尝试将数据/日志文件移动到大磁盘上.
https://docs.microsoft.com/zh-cn/sql/relational-databases/databases/move-database-files
如果您有与SQL Server相关的任何问题，建议您发布此问题在SQL Server论坛中，这样您将获得最合格的应答者池和其他合作伙伴 定期阅读论坛的人可以分享他们的知识.
If you have any issue related to SQL Server, I would suggest you post your issue in SQL Server forum so you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge.
这篇关于无法为数据库"WFInstanceManagementDB"中的对象"dbo.Instances"."PK_Instances"分配空间，因为"PRIMARY"文件组已满的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
