SQL Server Performance Forum – Threads Archive

Filegroup Error

Hi I am handling the migrtaion process during which I will be sent SQl 2000 backup from the application team and I am supposed to restore the on SQL server 2005. I restored the backup on SQL server 2005. Now my Maintenance Plans fail due to the following error Executing the query "BACKUP DATABASE [Upside50] TO DISK = N’W:\MSSQL\MSSQL.5\MSSQL\Backup\Upside50\Upside50_backup_200705031711.bak’ WITH NOFORMAT, NOINIT, NAME = N’Upside50_backup_20070503171137′, SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "The backup of the file or filegroup "sysft_upside-on_doc_clause_text-paragraph_txt" 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.
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. How can I bring a filegroup online? Thanks Roopa

I believe sql server 2000 database had fulltext search enabled… Check the following thread…
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=656578&SiteID=1
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Hey Thanks. You were right. It had full text search enabled.
Regards
Roopa

Follow the instrucations in the thread then let us know….
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

You say with the maintenance plan then ensure you have up to date service pack installed on SQL 2005. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

]]>