Immedeite Help Required! - Fulltext indexing

Hello All,
When I restore a backup on a different Server, It automatically creartes the
records in sysfulltextcatalogs which refers the Catelogue path of old
database.
How to come out of this Proble?
If I remove the records from sysfulltextcatalogs, then while enabling the
Database for Fulltext indexing, the below error occured.
" Full-text catalog '' has been lost. Use sp_fulltext_catalog to
rebuild and to repopulate this full-text catalog. "
Is there a way that we can remove the old catelogue references and re-create
and populate the Catelogues?
Warm Regards
Sahian
Hi
This may help:
http://support.microsoft.com/default...b;en-us;240867
John
"Sathian" wrote:

> Hello All,
> When I restore a backup on a different Server, It automatically creartes the
> records in sysfulltextcatalogs which refers the Catelogue path of old
> database.
> How to come out of this Proble?
> If I remove the records from sysfulltextcatalogs, then while enabling the
> Database for Fulltext indexing, the below error occured.
> " Full-text catalog '' has been lost. Use sp_fulltext_catalog to
> rebuild and to repopulate this full-text catalog. "
> Is there a way that we can remove the old catelogue references and re-create
> and populate the Catelogues?
> Warm Regards
> Sahian
>
>
|||John,
While that KB article talks about moving or copying FT Catalogs it does not
directly address the issue that Sathian is encountering relative to the
"Full-text Catalog has been lost" (due to deleting the entry in
sysfulltextcatalogs). Sathian, you can run the following T-SQL system stored
proc to 'clean up' or remove any FT Catalogs that are referenced in
sysfulltextcatalog, but not actually present on the server or in the
registry keys:
sp_fulltext_service 'Clean_Up'
This should "clean up" the registry keys and allow you to proceed. See
http://msdn.microsoft.com/library/de...ullad_2gtv.asp
for more details.
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:B792F9EB-983E-4E7E-84E0-17A0126167BF@.microsoft.com...[vbcol=seagreen]
> Hi
> This may help:
> http://support.microsoft.com/default...b;en-us;240867
> John
> "Sathian" wrote:
the[vbcol=seagreen]
the[vbcol=seagreen]
re-create[vbcol=seagreen]
|||Hi John
The removal of the record was by the OP,
"If I remove the records from sysfulltextcatalogs, then while enabling the
Database for Fulltext indexing, the below error occured."
He required:
"Is there a way that we can remove the old catelogue references and re-create
and populate the Catelogues?"
If he follows the article he can transfer the Full Text indexing correctly.
John
"John Kane" wrote:

> John,
> While that KB article talks about moving or copying FT Catalogs it does not
> directly address the issue that Sathian is encountering relative to the
> "Full-text Catalog has been lost" (due to deleting the entry in
> sysfulltextcatalogs). Sathian, you can run the following T-SQL system stored
> proc to 'clean up' or remove any FT Catalogs that are referenced in
> sysfulltextcatalog, but not actually present on the server or in the
> registry keys:
> sp_fulltext_service 'Clean_Up'
> This should "clean up" the registry keys and allow you to proceed. See
> http://msdn.microsoft.com/library/de...ullad_2gtv.asp
> for more details.
> Regards,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:B792F9EB-983E-4E7E-84E0-17A0126167BF@.microsoft.com...
> the
> the
> re-create
>
>
|||Hi John,
True. My only point is that the OP should not be manually removing records
from a system table as it is generally not recommended by Microsoft or by
MVP's to manually delete rows from any systems tables... However, the
"clean_up" parameter of sp_fulltext_service does - "Remove from the file
system all full-text catalogs that no longer have meta data for them in SQL
Server by executing this stored procedure". Note, the meta data includes the
entries in sysfulltextcatalogs as well as the FT Catalog registry keys that
are maintained by the MSSearch service.
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:A2BA13CF-D2AE-4557-AE46-C3D10D2CD188@.microsoft.com...
> Hi John
> The removal of the record was by the OP,
> "If I remove the records from sysfulltextcatalogs, then while enabling the
> Database for Fulltext indexing, the below error occured."
> He required:
> "Is there a way that we can remove the old catelogue references and
re-create
> and populate the Catelogues?"
> If he follows the article he can transfer the Full Text indexing
correctly.[vbcol=seagreen]
> John
> "John Kane" wrote:
not[vbcol=seagreen]
stored[vbcol=seagreen]
http://msdn.microsoft.com/library/de...ullad_2gtv.asp[vbcol=seagreen]
creartes[vbcol=seagreen]
old[vbcol=seagreen]
enabling[vbcol=seagreen]
sp_fulltext_catalog to[vbcol=seagreen]

Image Column Data and Backup

I have a table (SQL Server 2000) that stores icon files in an Image
field. I have no problem storing and retrieving the images on my system.
When I back up the database however the rows in that table do not seem
to get backed up. In other words when I restore the database on another
server there are no rows in that one table.
I have used the sp_tableoption to turn "in row text" on for the table
etc. Anyone have a clue what I might be doing wrong? This table will
eventually need to be recreated at a customer site with the data intact
and I was planning on just backing the database up and then restoring it.
Bob PorterA restored database will be exactly like the original, less uncommitted
transactions. A common cause of the problem you describe is that multiple
backups exist in the same backup file and the first (oldest) is restored by
default. You can list the backup file contents with RESTORE HEADERONLY:
RESTORE HEADERONLY
FROM DISK='C:\Backups\MyDatbase.bak'
You can then specify the desired backup with the FILE specification:
RESTORE DATABASE MyDatabase
FROM DISK='C:\Backups\MyDatbase.bak'
FILE=2
Hope this helps.
Dan Guzman
SQL Server MVP
"Robert Porter" <rhysliam@.noemail.nospam> wrote in message
news:ud2nToCbFHA.2128@.TK2MSFTNGP15.phx.gbl...
>I have a table (SQL Server 2000) that stores icon files in an Image field.
>I have no problem storing and retrieving the images on my system. When I
>back up the database however the rows in that table do not seem to get
>backed up. In other words when I restore the database on another server
>there are no rows in that one table.
> I have used the sp_tableoption to turn "in row text" on for the table etc.
> Anyone have a clue what I might be doing wrong? This table will eventually
> need to be recreated at a customer site with the data intact and I was
> planning on just backing the database up and then restoring it.
> Bob Porter|||Dan Guzman wrote:
> A restored database will be exactly like the original, less uncommitted
> transactions. A common cause of the problem you describe is that multiple
> backups exist in the same backup file and the first (oldest) is restored b
y
> default. You can list the backup file contents with RESTORE HEADERONLY:
> RESTORE HEADERONLY
> FROM DISK='C:\Backups\MyDatbase.bak'
> You can then specify the desired backup with the FILE specification:
> RESTORE DATABASE MyDatabase
> FROM DISK='C:\Backups\MyDatbase.bak'
> FILE=2
>
It did! Thanks, sorry for the newbie question I knew better... sigh...|||No problem. You're certainly not the first to run into this :-)
Hope this helps.
Dan Guzman
SQL Server MVP
"Robert Porter" <rhysliam@.noemail.nospam> wrote in message
news:%23J0MYlDbFHA.464@.TK2MSFTNGP15.phx.gbl...
> Dan Guzman wrote:
> It did! Thanks, sorry for the newbie question I knew better... sigh...

I'm requesting a support with the Backup Data Base through SQL Ser

I need help and support to execute of backup of a specific database. May you
help me How could I backup by schedule that specific data, sombody could help
me with that? Please it's important.
Best WishesThere are excellent chapters in Books Online about this topic. No need to re-iterate what is already
written on the topic. I suggest you read up on the subject and post again if you have more specific
questions.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Socorro del Carmen Rosas" <SocorrodelCarmenRosas@.discussions.microsoft.com> wrote in message
news:0B6EB9AD-5DB8-4EA6-8D81-AA65C2BF1918@.microsoft.com...
>I need help and support to execute of backup of a specific database. May you
> help me How could I backup by schedule that specific data, sombody could help
> me with that? Please it's important.
> Best Wishes|||Thank you so much Tibor it was useful, and it is working now.
Best Regards and God Bless you
"Tibor Karaszi" wrote:
> There are excellent chapters in Books Online about this topic. No need to re-iterate what is already
> written on the topic. I suggest you read up on the subject and post again if you have more specific
> questions.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Socorro del Carmen Rosas" <SocorrodelCarmenRosas@.discussions.microsoft.com> wrote in message
> news:0B6EB9AD-5DB8-4EA6-8D81-AA65C2BF1918@.microsoft.com...
> >I need help and support to execute of backup of a specific database. May you
> > help me How could I backup by schedule that specific data, sombody could help
> > me with that? Please it's important.
> >
> > Best Wishes
>

I'm requesting a support with the Backup Data Base through SQL Ser

I need help and support to execute of backup of a specific database. May yo
u
help me How could I backup by schedule that specific data, sombody could hel
p
me with that? Please it's important.
Best WishesThere are excellent chapters in Books Online about this topic. No need to re
-iterate what is already
written on the topic. I suggest you read up on the subject and post again if
you have more specific
questions.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Socorro del Carmen Rosas" <SocorrodelCarmenRosas@.discussions.microsoft.com>
wrote in message
news:0B6EB9AD-5DB8-4EA6-8D81-AA65C2BF1918@.microsoft.com...
>I need help and support to execute of backup of a specific database. May y
ou
> help me How could I backup by schedule that specific data, sombody could h
elp
> me with that? Please it's important.
> Best Wishes