Sql Server 2005

19 Nov 2007 9:00 PM

Salahu

Hi
   When i take back up database I got below error.

          System.Data.SqlClient.SqlError: The backup of full-text
catalog 'Help_Topics' is not permitted because it is not online. Check
errorlog file for the reason that full-text catalog became offline and
bring it online. Or BACKUP can be performed by using the FILEGROUP or
FILE clauses to restrict the selection to include only online data.
(Microsoft.SqlServer.Express.Smo)

   Please do the needful

20 Nov 2007 2:44 AM

Ben Nevarez

As recommended by the message check the SQL Server error log to see what the
problem is. Also take a look at this

http://support.microsoft.com/kb/923355

Hope this helps,

Ben Nevarez
Senior Database Administrator
AIG SunAmerica

Show quote

"Salahu" wrote:

> Hi
>    When i take back up database I got below error.
>
>           System.Data.SqlClient.SqlError: The backup of full-text
> catalog 'Help_Topics' is not permitted because it is not online. Check
> errorlog file for the reason that full-text catalog became offline and
> bring it online. Or BACKUP can be performed by using the FILEGROUP or
> FILE clauses to restrict the selection to include only online data.
> (Microsoft.SqlServer.Express.Smo)
>
>    Please do the needful
>

20 Nov 2007 8:48 PM

Salahu

Thanks Ben,
full text catalog now has been moved to C:\ from C:\Data then back
database to Online but till i got same error. Can u please suggest me?

Ben Nevarez wrote:
Show quote

> As recommended by the message check the SQL Server error log to see what the
> problem is. Also take a look at this
>
> http://support.microsoft.com/kb/923355
>
> Hope this helps,
>
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
>
>
> "Salahu" wrote:
>
> > Hi
> >    When i take back up database I got below error.
> >
> >           System.Data.SqlClient.SqlError: The backup of full-text
> > catalog 'Help_Topics' is not permitted because it is not online. Check
> > errorlog file for the reason that full-text catalog became offline and
> > bring it online. Or BACKUP can be performed by using the FILEGROUP or
> > FILE clauses to restrict the selection to include only online data.
> > (Microsoft.SqlServer.Express.Smo)
> >
> >    Please do the needful
> >