Cannot enable Full-Text search on Azure SQL Database V12

1.6k views Asked by At

I'm trying to enable Full-Text search on my Azure SQL Database. I upgraded my DB to V12 Standard instance. The upgrade has got completed successfully. I say that 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 saying,

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?

2

There are 2 answers

5
Satya_MSFT On BEST ANSWER

Executing the below two statements by connecting to the database as well fixes this if in case you want to avoid the round trip of communicating to MSFT.

 Alter database [dbname] set read_committed_snapshot off with rollback immediate
Alter database [dbname] set read_committed_snapshot on with rollback immediate
0
Joseph Idziorek On

Thank you for the question. The error you are experiencing is related to an internal issue that we are aware of and currently in the process of fixing. To mitigate your issue, could you please email me at joseidz at microsoft dot com with server and database name and we will get this fixed for you.