"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

"Enable user SQL instances"

Hi I have Visual Studio 2005 with SP1 installed, and I want to install the Management Studio. I tried many times installing that and I always got the same problem, which is when I try to create a database in VS I just don’t get trough as I used to. A message appears saying that I’ve to enable some estance. So to resolve the problem I saw if is everything ok with the SQL Server, which seemed to be fine, but I couldn’t start the Report service.

Now I just formatted the computer and I’m afraid to happen all over again. May be the version with only the Management would be fine, I don’t know if it adds something beside of that.

Thank you very much.

After installing Express, you need to explicitly enable remote connections. Is this the issue you are seeing? If not, please supply an exact error message or a log snippet showing the problem.

Thanks,
Sam Lester (MSFT)

|||

Was about "Enable user SQL instances" and the Report Service didn’t started too.

How do I enable this remote connections?

And in the instalation, Should I Add a user to the SQL Server Administration Role?

And also in the step "ready to install" of the SQL Server SP2 shows the following:

The following components will be installed:

· SQL Server Database Services (Upgrade)

(Database Services, Replication, Full-Text Search)

· Reporting Services

(Reporting Services, Report Manager)

· Client Components (Upgrade)

(Connectivity Components, Management Studio Express)

Warning: Setup found that the following components that already exist are at a different service pack level than the components being installed.

Components: Microsoft SQL Server 2005 Tools Express Edition, Microsoft SQL Server 2005 Express Edition (SQLEXPRESS)

After completing setup, you must download and apply the latest SQL Server 2005 service pack to all the components.

"Could not start the SQL Server Integration Services..."

Running MS SQL 2005 SP1 on Windows 2003 Server SP1 (IA32). Upon rebooting, I get an error that this service failed to start, and when I attempt to start manually, I get the same error:

Could not start the SQL Server Integration Services service on the Local Computer.

Error 1053: The service did not respond to the start or control request in a timely fashion.

Any ideas?

Have you looed at http://support.microsoft.com/kb/886695/ ?

Thanks,
Ovidiu Burlacu

|||I also recommend this one - http://support.microsoft.com/kb/918644 :)