Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 ').

share|improve this question
Awesome. An undocumented message number. Can you reproduce this in a small example? It may very well be a bug in SQL Server. – Jon Seigel Oct 7 '13 at 17:10
I'm trying to delete a table type FileTable (SQL Server 2012). When I do drop displays this message. – Camila Reis Oct 7 '13 at 17:14
Does this happen only for a particular database, or does it also happen if you create a new database and try to drop a FileTable from it? – Jon Seigel Oct 7 '13 at 17:16
@JonSeigel This happens with a specific database. Began to happen when trying to stop the database and canceled before completing. – Camila Reis Oct 7 '13 at 17:19
Okay. Have you run DBCC CHECKDB on this database? It sounds like it may have been corrupted by cancelling that operation. – Jon Seigel Oct 7 '13 at 17:35

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.

share|improve this answer
Oh well, at least you got it fixed somehow. Thanks for following up. – Jon Seigel Oct 16 '13 at 13:18

I found this on stackoverflow with the same issue. The solution there solved it for me. (Rename the Filestream Directory Name to something unique.)

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.