且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何完成删除文件流和所有附加文件

更新时间:2022-12-28 15:11:29

您可以检查:

SELECT * FROM SenONew.sys.data_spaces WHERE name = 'FileStream' 

它应该返回0行.

有一个过程可以从SQL Server 2008数据库中删除FILESTREAM功能:

There is a procedure to remove FILESTREAM features from a SQL Server 2008 database :

ALTER TABLE Filestore DROP column FileIndex
GO
ALTER TABLE Filestore SET (FILESTREAM_ON="NULL")
GO
ALTER Database SenONew REMOVE FILE fsSenONew
GO
ALTER Database SenONew REMOVE FILEGROUP [FileStream]
GO

as described in this article. But the steps you did should do the same thing.

您的问题当然很奇怪,但是我建议您尝试使用以下

Your problem is certainly strange, but I suggest that you try using following

USE SenONew
EXEC Sp_help 
EXEC Sp_helpfile 
EXEC Sp_helpfilegroup 

您可能会在其中找到可疑的东西,例如使用该FILEGROUP的另一个表.

You may find something suspicious there like another table using that FILEGROUP.

我已经完全按照您描述的步骤进行操作,无法重现您的问题.检查还原数据库"屏幕的外观.

I have done exactly the steps you describe and cannot reproduce your problem. Check how your Restore database screen looks like.