Error deleting FileTable - HRESULT = '0x80070490'

Question

When trying to delete a FileTable, the following error occurs:

Message 33405, Level 16, State 7, Line 1 Error during operation on an object table Discard FileTable. (HRESULT = '0 x80070490 ').

score 1 · Answer 1 · edited May 23 '17 at 12:40

1

I found this on stackoverflow with the same issue. The solution there solved it for me. (Rename the Filestream Directory Name to something unique.) https://stackoverflow.com/questions/29777357/sql-server-2012-filestream-an-error-occurred-during-the-drop-table-operation-o

edited May 23 '17 at 12:40

Community

1

answered Jul 23 '15 at 16:49

Jeff S.

11
1

score 1 · Answer 2 · answered Oct 16 '13 at 12:32

Due to the urgency we do not expect a return of support from Microsoft, but it seems that the error occurred due to attempt to put the database offline.

We solve the error as follows:

Since we had a base equal to the base model which showed the error, made the copy of the data base with an error (except FileTable) for the base model and recreate the FileTable. It was in this way that we solve.

Because we applied the solution before the return of support, they could not diagnose prescision.

Error deleting FileTable - HRESULT = '0x80070490'

2 Answers2