"sysft_Content" - what is it?

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

<<< I couldnt backup my SQL Databases >>> !!!

here is Codes
////////////////// textBox1.Text = ADEMTEKEREK (server
computer's name)
FileInfo SourceFile1=new FileInfo("\\\\" + textBox1.Text +
"\\c\\Program Files\\Microsoft SQL
Server\\MSSQL\\Data\\MYDATABASE_Data.Mdf");
FileInfo SourceFile2=new FileInfo("\\\\" + textBox1.Text +
"\\c\\Program Files\\Microsoft SQL
Server\\MSSQL\\Data\\MYDATABASE_Log.Ldf");
SourceFile1.CopyTo("D:\\",true);
SourceFile2.CopyTo("D:\\",true);
...and when i start my form, there is this Error Message
Could not find file"\\ADEMTEKEREK\c\Program Files\Microsoft SQL
Server\MSSQL\Data\MYDATABASE_Data.Mdf"
WHAT CAN I DO...'?
thnks for now....< wrote on 6 Apr 2006 02:02:09 -0700:

> here is Codes
> ////////////////// textBox1.Text = ADEMTEKEREK (server
> computer's name)
> FileInfo SourceFile1=new FileInfo("\\\\" + textBox1.Text +
> "\\c\\Program Files\\Microsoft SQL
> Server\\MSSQL\\Data\\MYDATABASE_Data.Mdf");
> FileInfo SourceFile2=new FileInfo("\\\\" + textBox1.Text +
> "\\c\\Program Files\\Microsoft SQL
> Server\\MSSQL\\Data\\MYDATABASE_Log.Ldf");
> SourceFile1.CopyTo("D:\\",true);
> SourceFile2.CopyTo("D:\\",true);
> ...and when i start my form, there is this Error Message
> Could not find file"\\ADEMTEKEREK\c\Program Files\Microsoft SQL
> Server\MSSQL\Data\MYDATABASE_Data.Mdf"
> WHAT CAN I DO...'?
> thnks for now....
Do you have a share named "c" on the machine ADEMTEKEREK that is mapped to
the root of drive c? Does the account this code runs under have access to
network shares?
I'd also recommend that you don't just copy the MDF and LDF files as a
backup - if these are in use by SQL Server you will likely end up with
unusable files. Have SQL Server do a BACKUP and then copy those files.
Dan