Error while performing Fullbackup after a filegroup restore.

System.Data.SqlClient.SqlError: The backup of the file or filegroup "CUSTBilling" 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)

I did a file group backup and restore of a database and then when I tried to perform a full backup I am getting the above error. Any thoughts. I indeed happen to see this error http://support.microsoft.com/default.aspx/kb/921106 but not sure if both errors are the same.

Santhosh
http://sqlspy.blogspot.comI assume that you did a backup and restore of the CUSTBilling file group? Did you ensure that the filegroup is back online after the restore completed?|||

According to the error message, not all of your filegroups were online when you attempted the full backup.

After your filegroup restore, were all of your filegroups online, or only some of them?

Backup cannot process offline filegroups, and a full backup is defined to process the whole database.

You need to either bring all filegroups online, or back up only the online filegroups using the FILEGROUP clause in your BACKUP statement.

The differential backup message is caused by the fact that you haven't successfully performed a full backup, and so the differential has no base on which to calculate the deltas.

Kevin

|||

I have the same problem.

I had a database on an SQL 2000 server and I copied the data into a new, SQL 2005 Express database that did not have fulltext indexing on. Now I'm trying to back up my database using the GUI, but I still get the error:

System.Data.SqlClient.SqlError: The backup of the file or filegroup 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)

There is no setting in the GUI about FILEGROUPs, or if there is, I can't find it. Do I need to write code to backup the database, can't I use the SQL Studio?

Thanks,

Janos

|||I have the same problem.
In my case I detached from 2000 and attached to 2005. The full text is checked

When I try to backup I get this error
Failed-1073548784) Executing the query "BACKUP DATABASE [PublicWorks] TO

" failed with the following error:
"The backup of the file or filegroup "sysft_Plats" 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 do I get the sysft_Plats on line?
If not what is the FILEGROUP or FILE clauses syntax?

Thanks in advance for your help.
|||Kevin,
How do you do that "You need to either bring all filegroups online, or back up only the online filegroups using the FILEGROUP clause in your BACKUP statement.

Can you tell me how to bring filegroups online?
OR
How to use the FILEGROUP clause?

Thanks in advance for your help

Tarig