更新时间: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.