Can't back up WSS content database since migration to RTM

When I try to backup my TFS databases, I'm getting an error:

System.Data.SqlClient.SqlError: The backup of the file of filegroup "sysft_ix_STS_server_#_####" 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.

Apparently the full-text indexes on the WSS content database have been lost/deleted/corrupted/? by something that happened during the migration to RTM.

Any ideas what I might be able to do to re-create the full-text indexes for the WSS content database?

[613 byte] By [CarlDaniel] at [2007-12-21]

«« RE-add witness fails
»» Problems setting up data in the Application Data directory

# 1

That is odd - the upgrade should not have deleted the full-text indexes. You can try rebuilding your full-text indexes:

ALTER FULLTEXT CATALOG <CATALOGNAME> REBUILD;

You should be able to get the catalog name by running:

select * from sys.fulltext_catalogs

Hope it helps. Cheers!

ChandruR at 2007-9-10 >

top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Setup...

# 2

That got my Content database going again, thanks!. I'm sure the troubles had something to do with the fact that I had to uninstall/reinstall SQL Server twice during the RTM upgrade.

CarlDaniel at 2007-9-10 >

# 3

I had the same issue:

This was my fix :-) (Which took me forever to find out as the web and MS yield, hmmm, lets see, NOTHING!!!

Fix =

sp_fulltext_database enable

Cheers

Ian

IanMcChristian at 2007-9-10 >

Visual Studio Team System

Team Foundation Server - Setup

Visual Studio Team System Hot Topic

Visual Studio Team System New Topic

Visual Studio Team System

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech