Conflict between backup and fulltext catalog

Sometimes the scheduled full backups on MY_DATABASE are not performed,
throwing the following error related with the fulltext catalog (CATALOG_XXX)
that it's used by some tables:
"The backup of the file or filegroup "sysft_CatalogXXX" 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.
[SQLSTATE 42000] (Error 3007) BACKUP DATABASE is terminating abnormally.
[SQLSTATE 42000] (Error 3013). The step failed."
How do I solve this error?
Thanks,
Gaspar.Are you trying to execute a backup while the fulltext catalog is being
rebuilt?
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Gaspar" <gaspar@.gaspar.com> wrote in message
news:utLKzokYGHA.4248@.TK2MSFTNGP05.phx.gbl...
> Sometimes the scheduled full backups on MY_DATABASE are not performed,
> throwing the following error related with the fulltext catalog
> (CATALOG_XXX) that it's used by some tables:
> "The backup of the file or filegroup "sysft_CatalogXXX" 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.
> [SQLSTATE 42000] (Error 3007) BACKUP DATABASE is terminating abnormally.
> [SQLSTATE 42000] (Error 3013). The step failed."
> How do I solve this error?
> Thanks,
> Gaspar.
>

Conflict between backup and fulltext catalog

Sometimes the scheduled full backups on MY_DATABASE are not performed,
throwing the following error related with the fulltext catalog (CATALOG_XXX)
that it's used by some tables:
"The backup of the file or filegroup "sysft_CatalogXXX" 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.
[SQLSTATE 42000] (Error 3007) BACKUP DATABASE is terminating abnormally
.
[SQLSTATE 42000] (Error 3013). The step failed."
How do I solve this error?
Thanks,
Gaspar.Are you trying to execute a backup while the fulltext catalog is being
rebuilt?
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Gaspar" <gaspar@.gaspar.com> wrote in message
news:utLKzokYGHA.4248@.TK2MSFTNGP05.phx.gbl...
> Sometimes the scheduled full backups on MY_DATABASE are not performed,
> throwing the following error related with the fulltext catalog
> (CATALOG_XXX) that it's used by some tables:
> "The backup of the file or filegroup "sysft_CatalogXXX" 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.
> [SQLSTATE 42000] (Error 3007) BACKUP DATABASE is terminating abnormal
ly.
> [SQLSTATE 42000] (Error 3013). The step failed."
> How do I solve this error?
> Thanks,
> Gaspar.
>

Configuring ole db provider for Indexing Service

Hi:

Am trying to access a Indexing Services catalog from SSIS. Problem is configuring the Data Connection.

I chose New Connection, Provider=Microsoft OleDB provider for Indexing Services.

Then I am not quite sure what to fill in for:

A. Server or File Name (I tried the IP address, the machine name, catalog name)

B. Location(tried catalog Name, ip address, machine name)

The Log On to Server frame is disabled.

Test Connection succeeds, but trying to use a Table or a Query does not work out.

How do I configure the Connection?

TIA

Kar

I thought this would be simple enough, but I cant get it to work. Cant find much help on MSDN/BOL either.

Hope somebody here can help me!

TIA

Kar

|||

The following may be a good starting point:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdrefindservprovspec.asp

In general, when searching for OLE DB related information, you can usually also search in docs for technology that uses OLE DB, such as ADO. Things like connection string info and command syntax are usually just pass-through from those technologies to OLE DB, so their documentation will most likely apply.

|||

Thanks,

I managed to get it work, but the nomenclature(OLE DB versus SSIS Connection Manager Editor) is ambiguous.

The Provider part of the string is fine, but the other property names do not match.

I suppose Server or file Name=Data Source=catalog name, and

Location = Locale ID or probably it is the Server name if you are connecting to a remote server?

Best regards

Kar

Configuring ole db provider for Indexing Service

Hi:

Am trying to access a Indexing Services catalog from SSIS. Problem is configuring the Data Connection.

I chose New Connection, Provider=Microsoft OleDB provider for Indexing Services.

Then I am not quite sure what to fill in for:

A. Server or File Name (I tried the IP address, the machine name, catalog name)

B. Location(tried catalog Name, ip address, machine name)

The Log On to Server frame is disabled.

Test Connection succeeds, but trying to use a Table or a Query does not work out.

How do I configure the Connection?

TIA

Kar

I thought this would be simple enough, but I cant get it to work. Cant find much help on MSDN/BOL either.

Hope somebody here can help me!

TIA

Kar

|||

The following may be a good starting point:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdrefindservprovspec.asp

In general, when searching for OLE DB related information, you can usually also search in docs for technology that uses OLE DB, such as ADO. Things like connection string info and command syntax are usually just pass-through from those technologies to OLE DB, so their documentation will most likely apply.

|||

Thanks,

I managed to get it work, but the nomenclature(OLE DB versus SSIS Connection Manager Editor) is ambiguous.

The Provider part of the string is fine, but the other property names do not match.

I suppose Server or file Name=Data Source=catalog name, and

Location = Locale ID or probably it is the Server name if you are connecting to a remote server?

Best regards

Kar