upgraded 2000 - 2005 and applied sp1.
also same failure with SQL 2005 from scratch
tried to do a simple Backup Database of a db named 'msu' to a disk file on a local hard drive just like I would with 2000. failed with:
System.Data.SqlClient.SqlError: The backup of the file or filegroup
"sysft_Content" is not permitted because it is not online.
BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the
selection to include only online data. (Microsoft.SqlServer.Smo)
That is your fulltext catalog. It needs to be rebuilt after the upgrade.
In sql2005, backups include fulltext, just like regular database and log files.
The fulltext catalog is modeled as a single "file".
You can take one of these actions and then try the backup again:
1) rebuild the catalog (the rebuild doesn't need to complete, and the re-crawl doesn't have to be triggered either)
2) drop the catalog
3) perform a file backup rather than full backup.
We are working on a KB article to address this problem, but it's not ready yet.
|||Rebuild All - Failed to rebuild full-text catalog.
--Property PopulationStatus is not available for FullTextCatalog '[Content]'.
This property may not exist for this object,
or may not be retrievable due to insufficient access rights.
New Catalog & Drop Catalog - Cannot execute changes.
--Create failed for FullTextCatalog 'dfgdfg'. (Microsoft.SqlServer.Smo)
Full-Text Search is not enabled for the current database. Use sp_fulltext_database to enable full-text search for the database. The functionality to disable and enable full-text search for a database is deprecated. Please change your application. (Microsoft SQL Server, Error: 7616)
EXEC sp_fulltext_database 'enable'; - "Completed Successfully"
but still get the "Full-Text Search is not enabled" messages
login 'sa'
Could you check if msftesql service is running properly?
Is msftesql service running in a different service account?
I suspect there is some problem due to upgrade so that full-text is not running properly.
thanks,
Jingwei
