SQL Server Performance Forum – Threads Archive

Migration Error

Hi ,
I am getting the following error when we restore the database from SQL 2000 to SQL 2005. "Data.SqlClient.SqlError: The backup of the file of filegroup "sysft_ftMAGIC" 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." How to fix this. Thanks
Roopa

---

See if this helps your case: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=656578&SiteID=1 Satya

---

Is it a piecemeal restore from the backup?
Are you using Fulltext? 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. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

Remember, in SQL2000 FullText catalogs are NOT included in the backup. In 2005 FT’s are included in the full db backup, but that’s not going to do any good for you, yet. <img src=’/community/emoticons/emotion-5.gif’ alt=’‘ /><br /><br />Best bet is to ignore the error and manually rebuild your FT’s on the new server (that’s what I do…).

---

]]>