Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
1  
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
show 7 more comments

1 Answer

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
add comment

Your Answer

 
discard

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.