Unable to enable full text search on Azure SQL Database V12
I am trying to enable full text search on my Azure SQL Database. I have upgraded my DB to a V12 Standard instance. The update completed successfully. I say this because the Status says "Online" on the portal. However, when I execute this command below,
CREATE FULLTEXT CATALOG ftCatalog AS DEFAULT;
it throws an error message,
Msg 9972, Level 16, State 100, Line 2
Database is not fully started up or it is not in an ONLINE state. Try the full-text DDL command again after database is started up and becomes ONLINE.
I am following this blog post
What could be wrong?
source to share
Performing the below two instructions by connecting to the database also fixes this if you want to avoid two-way communication with MSFT.
Alter database [dbname] set read_committed_snapshot off with rollback immediate
Alter database [dbname] set read_committed_snapshot on with rollback immediate
source to share
Thanks for the question. The error you are experiencing is related to an internal issue that we are aware of and are currently in the process of being fixed. To mitigate your problem, can you please email me joseidz at microsoft dot com with the server and database name and we will get this fix for you.
source to share