* SQL 2005 Backup fails *

Hi,
I get this error when I try to backup my database:
System.Data.SqlClient.SqlError: The backup of the file or filegroup
"sysft_search" 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)
Any suggestions?
Thanks
Aras
It seems like that filegroup is OFFLINE
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<ageylani@.gmail.com> wrote in message news:1132031733.247332.327150@.g43g2000cwa.googlegr oups.com...
> Hi,
> I get this error when I try to backup my database:
> System.Data.SqlClient.SqlError: The backup of the file or filegroup
> "sysft_search" 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)
> Any suggestions?
> Thanks
> Aras
>
|||here are some sys queries if it helps you
USE inkeo
GO
SELECT * FROM sysfilegroups
SELECT * FROM sysfiles
groupid allocpolicy status groupname
-- -- -- --
1 0 16 PRIMARY
(1 row(s) affected)
fileid groupid size maxsize growth status perf name filename
-- -- -- -- -- -- -- --
1 1 2208 -1 10 1048578 0 cdgstore_Data D:\inkeo_Data.mdf
2 0 128 -1 10 1048642 0 cdgstore_Log D:\inkeo_Log.ldf
(2 row(s) affected)
SELECT @.@.VERSION shows this
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005
00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Enterprise
Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
|||What about
select name, state_desc from sys.database_files
Ben Nevarez, MCDBA, OCP
Database Administrator
"ageylani@.gmail.com" wrote:

> here are some sys queries if it helps you
> USE inkeo
> GO
> SELECT * FROM sysfilegroups
> SELECT * FROM sysfiles
> groupid allocpolicy status groupname
> -- -- -- --
> 1 0 16 PRIMARY
> (1 row(s) affected)
> fileid groupid size maxsize growth status perf name filename
> -- -- -- -- -- -- -- --
> --
> 1 1 2208 -1 10 1048578 0 cdgstore_Data D:\inkeo_Data.mdf
> 2 0 128 -1 10 1048642 0 cdgstore_Log D:\inkeo_Log.ldf
> (2 row(s) affected)
> SELECT @.@.VERSION shows this
> Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005
> 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Enterprise
> Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>
|||cdgstore_DataONLINE
cdgstore_LogONLINE
sysft_searchOFFLINE
Interesting! I think sysft_search must have came from SQL 2000. I saw
same failures in all otherdatabases imported from a backup from SQL
2000 ! Anyways, now what you suggest?
Regards,
Aras
|||My guess is that this is the full-text index catalog. I'm not FT person, but my guess is that this
doesn't come online until you repopulate (or something) the catalog.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<ageylani@.gmail.com> wrote in message news:1132095781.722737.151390@.z14g2000cwz.googlegr oups.com...
> cdgstore_Data ONLINE
> cdgstore_Log ONLINE
> sysft_search OFFLINE
> Interesting! I think sysft_search must have came from SQL 2000. I saw
> same failures in all otherdatabases imported from a backup from SQL
> 2000 ! Anyways, now what you suggest?
> Regards,
> Aras
>